Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I'm new to Power BI and i'm migrating a NAV based QlikView application to Power BI.
Probably a simple question, but how can I calculate the max value of a field within the data load process (after querying the data from the DB)?
Thanks in advance!
Solved! Go to Solution.
In Power Query language (M) there is List.Max and Table.Max:
https://msdn.microsoft.com/en-us/library/mt260763.aspx
In DAX, you could create a measure and use the MAX function:
https://support.office.com/en-US/article/MAX-Function-DAX-79baa07f-5b6c-4cec-a372-b1ea60e33574
List.Max(Sales_Line_Archive[Version No_]) fixed it. I had to remove all duplicate values
In Power Query language (M) there is List.Max and Table.Max:
https://msdn.microsoft.com/en-us/library/mt260763.aspx
In DAX, you could create a measure and use the MAX function:
https://support.office.com/en-US/article/MAX-Function-DAX-79baa07f-5b6c-4cec-a372-b1ea60e33574
List.Max(Sales_Line_Archive[Version No_]) fixed it. I had to remove all duplicate values
How do I set a max function so that each row returns the Max Value of the past X days? (I.e. For a row labeled March 27th, the cell will return the largest value between 3/8 and 3/27, March 28th would return the largest value between 3/9 and 3/28, etc.)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.