Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate Historical value based on value

Need help with calculating historcal data. I have data for Column A-D. But want to Calculate (with DAX) E. Col D i så always the act. value. And Col E can be reverserd calculated.   Ex.   Col...
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    you can do that with a calculated column.

    Try the following formula:

    RealAct = 
VAR vDateRow = myTable[Date]
VAR vLastDate = MAX( myTable[Date] )
VAR vAct = myTable[Act]
VAR vFilterTable = FILTER( myTable, myTable[Date] >= vDateRow && myTable[Date] < vLastDate )
RETURN
    vAct - SUMX( vFilterTable, myTable[Net] )

     

    For me that works:

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

you can do that with a calculated column.

Try the following formula:

RealAct = 
VAR vDateRow = myTable[Date]
VAR vLastDate = MAX( myTable[Date] )
VAR vAct = myTable[Act]
VAR vFilterTable = FILTER( myTable, myTable[Date] >= vDateRow && myTable[Date] < vLastDate )
RETURN
    vAct - SUMX( vFilterTable, myTable[Net] )

 

For me that works:

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Nice! Thx 😄