The Simplest Guide for Power BI Dataflows There are resources out there explaining what dataflows are in Power BI. But they often include some jargon and are not straight to the point. I simplified as much as I can so that you spend less time in understanding what they are and when you should use…
Month: March 2023
Calculate the Max Sales Amount for Product
Setup I use the Contoso data model. You can access it dax.do or download pbix here. The data model looks like this: Code The result looks like this: Validating the output: Here’s the full code I used in dax.do: Explanation VALUES() gets unique products from product table. You could just reference the table, but I…