CODEWITHSUNDEEP
powerbidax
Sca
Sca

Reputation: 195

How to calculate most recent (date wise) and MAX of prodcount in power BI using DAX

enter image description hereIn power BI using the in built functionalities , i have achieved how to take out the most recent production count (MAX) by the following steps:

1. Relative date filtering by 1 day (including today) and Choosing the latest date value in the Viz section
2. Filtering shift to TOP N , TOP 1 by LATEST time
3. Choosing the max value of production count in Viz section

I want to create a measure for only showing the production count of the highlight as in the picture

Upvotes: 0

Views: 541

Answers (1)

Strawberryshrub
Strawberryshrub

Reputation: 3389

This measure will do the trick:

enter image description here

Upvotes: 1

Related Questions