locked
How to get previous value against the data using DAX RRS feed

  • Question

  • Hi everyone,

    I need to get the previous date value using DAX... below here is the scenrio:

    Date is coming from dim date table and Amount is coming from transaction table

    relation: dim_date[date] with transaction[trans_date]

    I need the Previous amount value

    How to get the previous transaction amount using DAX...

    plz help me on that...

    Thursday, April 2, 2015 11:08 AM

Answers

  • This could also easily be done beforehand in Power Query,

    Copy the table, load it into a query and add an index-column, starting with 1. Then load the other table and add an index column starting with 0. Join them on index-column and you get your desired columns.

    But if you want to do it in PP instead, take a calculated column like this:

    =CALCULATE(MAX([Amount]), FILTER(YourTable, YourTable[Date]=EARLIER(YourTablee[Date])-1))


    Imke

    Thursday, April 2, 2015 12:46 PM
    Answerer