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.
can you please help me create a dax for calculating the sum of the daily production where my day starts at 5:00 am, and ends at 5:00am next day. also ny weekly production starts 5:00 am Sunday to 5:00 am sunday of the next week.
in other words, my day starts at 5:00 am not 12:00 am
Solved! Go to Solution.
Hi @dqG9kYbAmF7tfNx,
You can create two calculated columns like below:
NewDateTime = Table1[DateTime]-5/24
NewDate = Table1[NewDateTime].[Date]
Then create a measure:
Hi @dqG9kYbAmF7tfNx,
You can create two calculated columns like below:
NewDateTime = Table1[DateTime]-5/24
NewDate = Table1[NewDateTime].[Date]
Then create a measure:
Thank you, this is amazing. I still don't know much how it works
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |