Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Help

Hi, I am trying to replicate the below Excel Calculation in Power BI: (Calculated Column)   Formula: AD Line = AD Line (previous value) + Net Advances (Current Value) For the 1st row, AD Line = ...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Hi Anonymous ,

    Recursive calculated columns are a nightmare to be honest, but I got around it in your example. Your AD line is basically the SUM of all net advances of every row before the current row, plus the net advances of the current row. So, your AD Line will be calculated using the following calculated column:

    AD Line2 = 
VAR curDate = Table2[Date]
RETURN
CALCULATE(SUM(Table2[Net Advances]), FILTER(ALL(Table2), Table2[Date] <= curDate))

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Kudo's are welcome 🙂

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

Hi Anonymous ,

Recursive calculated columns are a nightmare to be honest, but I got around it in your example. Your AD line is basically the SUM of all net advances of every row before the current row, plus the net advances of the current row. So, your AD Line will be calculated using the following calculated column:

AD Line2 = 
VAR curDate = Table2[Date]
RETURN
CALCULATE(SUM(Table2[Net Advances]), FILTER(ALL(Table2), Table2[Date] <= curDate))

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Kudo's are welcome 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

JarroVGIT  Thank you so much! That worked 🙂