Forum Discussion

rtse's avatar
rtse
Frequent Visitor
8 years ago

Calculating Difference on one column - comparing value received today vs prior day.

Hi   I am new to POWER BI and am trying to build a visualization that displays the differences between number of records loaded day over day.     I have a query which pulls current day and prior ...
Need Help
rtse's avatar
rtse
Frequent Visitor
8 years ago

My table

rtse's avatar
rtse
Frequent Visitor
8 years ago

each row represents a different job - referenced by path name row by row in the column Clean PACE Data Path 

 

End_date column contains 2 dates 7/14 and 7/15, will always have today and today-1 

 

I would like the result to be:

 

Desired end result

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi rtse,

     

    For your expected result, you could create two measures to calculate the num_processed for Today and previous day.

     

    You could create the measure with formula like below.

     

    T-1= CALCULATE(expression ,DATEADD('Table'[Date],-1,DAY))

    If you still need help, please share your data sample as table so that I could test with it, otherwise it will take a long time for me to create your data model.

     

    Best Regards,

    Cherry