Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I am struggling with one of my report. I don't understand why it is not showing up the right results.
I need to calculate points accrued for a client. Points are accrued each month and carried over if any left.
For this, I have used a cumulative measure as follows:
Then I use the following to know how many vouchers I need to give away (1 voucher for every 150 points).
I don't understand why the cumulative is not showing up for Jan. The client didnt make any purchase that month but I thought it will still carry over? Also I don't understand the -18 in Jan or 18 in March. With the cumulative results adding up for January even thought the client didnt purchase, will give me the right results for the voucher.
Can someone please help with the formula to fix this?
You can access the pbix file here if that can be useful: https://1drv.ms/u/s!AiS7XVNuQsBCfLR3YfEnr4wJxEo?e=fM0NE4
Thank you.
Solved! Go to Solution.
Hi,
Is this the result you are expecting? Download the PBI file from here.
Hi,
Is this the result you are expecting? Download the PBI file from here.
Hi Ashish,
Thank you so much. Exactly what I was after.
Thanks.
You are welcome.
This might get you a little further.
1. Calendar - mark this as a date table
2. Sample formula
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |