Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
For a set of percentages split by location and period , I need to obtain a detail for each location and for each period as a percentage of the previous months multiplied, as follows:
Cheers,
Dorin
In case you only looking this month and last month. Have you calculation like this and use them in multiplication
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date Filer])) Last month Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date Filer],-1,MONTH))))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Thanks @amitchandak ,
However it's not what I need.
First of all If you take a look at the expected result:
1.for February the solution should create lines for all the periods from the beginning to the current period - in this case two lines both January and February and those 2 months to have calculated amounts as follows:
2. For March we would need to create 3 lines from the beginning of the period,- in this case Jan, Feb and Mar and have the values computed as follows:
It's quite tricky. Hope my explanations clarifies a bit the problem.
Cheers,
Dorin
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |