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.
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.
Solved! Go to 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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |