Help to understand microsoft tutorial

[CAbanto]

Hello everyone, I am new to POWER BI and I am starting by following the tutorials available at Microsoft, however there is one detail that is blowing my mind. Indicates "Which day had the most sales in February 2019?" but in the tutorial report that answer is not indicated. Could someone tell me if I'm wrong or show me how they come up with the answer?

Link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dimensional-model-report

[amitchandak]

@CAbanto , You can use TOPN or New index function for that

Max Sales=

Sumx(keepfilters(topn(1, allselected('Date'[Date]) ,_roll18, desc)),[Sales])

Max Day

Max Sales=

topn(1, allselected('Date'[Date]) ,_roll18, desc)

Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ