Forum Discussion
Verifying customers declaration - turnover
pawelj795 , Check if this can help
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)
pawelj795 , Check if this can help