Forum Discussion
Jarrod
Helper III
Helper IIICumulative Sales Measure Not Accounting for Missing Intervals
I am currently working on a report to track cumulative sales over 15-minute intervals, but I'm facing a challenge with my DAX measure. I need it to calculate the cumulative sales for selected product...
Hi,
Please check the below picture and the attached pbix file whether it suits your requirement.
Jihwan_Kim
Super User
Super UserHi,
I suggest having a star schema data model with dimension tables, instead of having one big flat table.
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
JarrodHelper III
Helper IIIHi, I have a start schema.
Fact_Sales
Dim_ProductTypes
Dim_Shifts
Dim_Intervals
If there is a better way to write this Dax, please advise.
- Jihwan_Kim
Hi,
Please share the link of your sample pbix file, and then I can try to look into it.
Thank you.
- Jarrod
Hi Jihwan, please see sample file.
https://drive.google.com/file/d/1ml7o6G2YYAyfkZapheCvbtCWKjvyiYkb/view?usp=drivesdk
- Jihwan_Kim
Hi,
Please check the below picture and the attached pbix file whether it suits your requirement.