Display Data for Latest Date Rather than Sum of Data

[Anonymous]

Hello,

For our organization we have a utilization dashboard that tracks work hours on a day by day basis.  Reports get uploaded to a SharePoint every morning and Power Bi pulls them in, power query is used to extract the date from the report and create a column, tagging each row in the report with the date. I then use this date column in a slicer to allow the user the ability to look at a specific date.  Each report includes the hours from the 1st of the month to the selected date.  

When multiple days are selected the hours for the days get added together.  For example, the mesaure calculating indirect overtime is,

TotalOvertimeIndirect = CALCULATE(SUM('Hours Data'[OVERTIME Hours]), 'Hours Data'[ JobName (1)] = "Indirect Labor") + 0

I'm wondering, if it is possible that when multiple dates are selected in the date slicer the measures just show the data for the latest date.  For example, if June 16th and June 17th were both selected, the measures would just show the data for June 17th.

Thanks.

[parry2k · Accepted solution]

@Anonymous what you need to update your measure

Measure = 
VAR __latestDate = MAX ( Table[Date] ) --column that used in slicer
RETURN
CALCULATE ( <your existing measure>, Table[Date] = __latestDate ) 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

@parry2k Thank you! Worked perfectly!