Forum Discussion

Satya2804's avatar
Satya2804
Frequent Visitor
3 years ago

How to avoid circular dependency using previous row

Below is a sample data - first 3 columns are my inputs. Total Supply, Match and Long are my calculated columns.    Total Supply = Current Quarter Supply + Previous quarter Long. Example Total Suppl...
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
3 years ago

Do you need this in Power BI? As a measure or calculated column?  Or can it be done in Power Query?

Satya2804's avatar
Satya2804
Frequent Visitor
3 years ago

Was trying to solve for it in a measure, but even if it is a PowerQuery it works..