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 day files loaded into the database.  The columns stay the same.  I only have one date column which is end_date.  My data table is named PACE events.   And I would like to determine the difference in column num_processed which reflects records processed daily.  

 

eg.  July 17th num_processed - July 16 num_processed 

 

Thanks 

Need Help

4 Replies

  • 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

        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