Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I'm trying to create a cumulative measure for delivered tons in my model. I have a date dimension and a time dimension as we need it down to the hour. The issue I'm having is I can't figure out how to properly write the dax to cumulate across days, when the time dimension(hour) is placed. I need it to increment with each hour, but once it resets to hour 1 then next day, it also resets the cumulative tons.
The measure needs to filter out loads that haven't yet been delivered which I have created a hour table with 25 values 24 being the null value in this case:
This is the measure:
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
14 | |
12 | |
10 | |
9 |