Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello community!
I have a measure that counts the records in my transactional table and accumulates them to generate a curve. The problem is that I need the curve to only show the cumulative until the last filtered date of my transactional table (ENROLLMENT)
My measurement is as follows:
What I need is for the accumulated to end up in the last record of the filtered transactional table (the table affected by the filter context). In the case of the example that ends on 27/03, but taking into account that it must conform to what you have in the filter context.
I attach the data model:
I would greatly appreciate your help!
Best regards!
Agustin Romero
Hi @Syndicate_Admin ,
I put [NE] in and found that 6/5/2021 is 23 instead of 1. What is the logic of your formula?
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply.
The measure [NE] is the account of the translational table 'ENROLLMENT'.
the difference is because the cumulative xne measure 202101 has a calculate() modifier that shows the year before the same date
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |