Forum Discussion
Max() value of field
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!
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
3 Replies
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.)
