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
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi rtse,

 

It seems that you have more than one table. To get the solution, I want to know your data model.

 

If it is convenient, could you share your data sample and your desired output?

 

Best  Regards,

Cherry

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