Forum Discussion
dirkkoch
Helper III
Helper IIIDynamic Calculation of weekly Total
Dear all, I am currently struggling with a DAX calculation. The objective is to conduct a dynamic calculation related to weekly time intervals. The starting point is a dynamic value showing tod...
v-deddai1-msft
Community Support
Community SupportHi dirkkoch ,
Sorry for late response. There's something wrong with content in your pbix file. Would you please check for it?
Best Regards,
Dedmon Dai
dirkkochHelper III
Helper IIIHi v-deddai1-msft , it should be fixed now.
- v-deddai1-msft
Hi dirkkoch ,
Your sample data model is in a mess. It contains many to many relationship which prevents the formula from calculated precisely.
Best Regards,
Dedmon Dai
- dirkkoch
Hi v-deddai1-msft ,
I have fixed the data model (now one to many relationships) but I still do not get the Total calculated precisely as described. Would you mind taking another look at the file: https://1drv.ms/u/s!AhoYRiG8ci7wrxgUbLIhcew8gAXR?e=r4DYyoThanks!