Forum Discussion
pawelj795
6 years agoPost Prodigy
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...
- 6 years ago
pawelj795 , Check if this can help
amitchandak
6 years agoSuper User
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.
pawelj795
6 years agoPost Prodigy
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)
- amitchandak6 years agoSuper User
pawelj795 , Check if this can help