The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hello All,
Could you please help me with the DAX,. I do have a case where i need to calcualte the total and carryforward. In the below example:
In the above example A abd B are two Elements in April Total = A+B.
The Ending total of A is the begining value of May .....
Please help with DAX.
Regards
Hi @Anonymous
Please clear me if you have data like this
If so, to get expected result, please use loop with DAX in Power BI.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey,
may I suggest this article https://www.daxpatterns.com/time-patterns/
I think that almost every date related calculation is described in one or the other way.
You may also have a closer look at these DAX functions
OPENINGBALANCE...
CLOSINGBALANCE...
Hopefully this provides some additional ideas.
Regards,
Tom
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
106 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |