Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculated column with DATEADD

Hi, new to Power BI.  I'm trying to create a Prior day measure and current day measure to calculate the difference in records processed (num_processed) in my data table over distinct events day over ...
Need Help
PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago
Anonymous What's your expected output ?
Anonymous's avatar
Anonymous
Not applicable
7 years ago

based on each unique event name - difference between num_processed T-1 vs T.

 

 

 

eg.  event name ISGFileShare\CDFD\trigger_prp_ca.txt 

Nov 5 - num_processed 4374

Nov 4 - num_processed 4374

 

Difference = 0

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Would like a calculated measure.   Thanks 

    • PattemManohar's avatar
      PattemManohar
      Icon for Community Champion rankCommunity Champion
      7 years ago
      Anonymous Thanks for that, but it wasn't clean to copy and paste the data (As it is loosing its alignment when coping it as is). Could you please post the same in proper copiable format.
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I'm not sure how to copy it so that you can see it in this forum from BI.  Suggestions ?