Forum Discussion
Solved
Verifying customers declaration - turnover
Hi, I'm currently working on creating a report page that will show the realization of customers declaration about turnover. If they carry out a promise, they will get a proper discount. Cust...
pawelj795 , Check if this can help
I need a bit more info, but if I understand your problem correctly, then add a Measure for Period Duration which calculates the DATEDIFF between the max value of End Date or Date Selected and min value Start Date or Date Selected. Divide the Declared Turnover for Period by that measure.
AllisonKennedy
Another problem is that both dates (Start & End) must be inactive relationships.
What else do you need for helping me?pawelj795 , see my update above helps.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
amitchandak
Thanks for your solutions, but they are quite different than my case.
Below my sample data.https://drive.google.com/file/d/1TZdTBmvU2J72w15ULnQTlLqeJQjr4vz5/view?usp=sharing
As you can see on my file, when I filter data on my page, the declared turnover don't change, and I want to divide it according to days spent. (for example, if I choose Q2, it should be shown only declared turnover * 180/360)
