Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
RyanBentham
Kudo Kingpin
Kudo Kingpin

Help with a Recursive DAX calculation or workaround

Hey all

 

Hoping someone might be able to assist with a challenge I have in trying to replicate a recursive excel based formula.    I understand that DAX doesn't handle these type of calculations well (or even at all) so any workaround would be much appreciated.

 

Here are the current calculations:

 

RyanBentham_1-1624472778288.png

 

 

Basically, we have a schedule of Allocations and Expired Units which are fixed values.   

 

We then have 2 calculations that reference one another.    The "Consumed" measure is simply taking the minimum value of the Rolling Calc and Allocation measures.

 

The Allocation measure however, references itself (prior week value) as well as referencing the Consumed measure (prior week value).

 

I've been scrating my head all day on this and can't figure out how to replicate using DAX.

 

Any help would be hugely appreciated

 

Thanks

 

1 REPLY 1
daxer-almighty
Solution Sage
Solution Sage

Hi there

 

We need raw data in text form to have something to work with.

 

Thanks.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.