USERELATIONSHIP DAX Function: Use Inactive Relationships in Power BI
Many tables have more than one date: an order has an Order Date, a Ship Date and a Delivery Date. Power BI allows onl…
November 19, 2026Many tables have more than one date: an order has an Order Date, a Ship Date and a Delivery Date. Power BI allows onl…
Personal Blog | Virvijay November 19, 2026GROUP BY gives one row per group, but many analysis questions need the detail rows and a calculation across them: ra…
Personal Blog | Virvijay November 18, 2026Users often want the same chart to show different things: Sales today, Profit tomorrow, Orders next week; or the same…
Personal Blog | Virvijay November 17, 2026Raw tables have one row per order, but business questions are about totals: sales per region, orders per customer, av…
Personal Blog | Virvijay November 16, 2026Every month you get twelve branch files, or one sales file per day, and someone has to copy-paste them into one sheet…
Personal Blog | Virvijay November 15, 2026IF is the first "smart" formula most people learn in Excel. On its own it checks one condition. Combine it …
Personal Blog | Virvijay November 14, 2026Every Power BI developer hits this question sooner or later: should I create this column in Power Query or with DAX …
Personal Blog | Virvijay November 13, 2026Duplicate rows are one of the most common data problems in Excel. A customer appears twice, an order is copied by mis…
Personal Blog | Virvijay November 12, 2026Real data almost never sits in one table. Customers are in one table, orders in another, products in a third. To answ…
Personal Blog | Virvijay November 11, 2026Before 2019 you needed AutoFilter, helper columns or a long INDEX/SMALL array formula to pull matching rows out of a …
Personal Blog | Virvijay November 10, 2026