Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Need help in DAX

Hi,   I have below table. I don't have Previous Day column and wanted create Total Value column as per the below table. Is it possible to get that. The first date in a month I wanted to pass as zer...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

No, as I mentioned need day wise that calculated column Total Value.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    No, the previous day values I am using it for comparison purpose not for adding. so running will not work.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      It is not clear to me what your desired output is. Please elaborate.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        actually the formula for Total Value is SUM(A+B+C-(Targetvalue-Previousdayvalue). For 1st day of month previous value is zero as a static value passing. whatever value I am getting that value should pass it on 2nd day total value.

         

        For 2nd day the Total value is SUM(A+B+C -(Targetvalue-1stdayTotalvalue).

        2nd day, 1stdayTotalvalue will become previousday value for 2nd day.

         

        For 3rd day  total value is SUM(A+B+C-(Targetvalue-2ndtotalvalue).

        3rd day, 2nd day Total Value will become previousday value for 3rd day..

        and so on.