Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculating difference between consecutive rows

hello   i am new to power bi , and i have some struggle with this.    my data look like this (small portion:) DATE / sum 2018-07-01 / 200 2017-09-03 / 400 2016-19-04 / 500   i want to calcu...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi all,

     

    i manged to solve this using this answer:

     

    Answer

     

    basicly i had to calculate for each date the previous date (under the current filters) and then return the result for that date

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

Please provide a sample of the original data. Since the dates aren't in order by dates, how can we determine which one is former, which one is latter?

 

 

Best Regards,
Dale

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi all,

 

i manged to solve this using this answer:

 

Answer

 

basicly i had to calculate for each date the previous date (under the current filters) and then return the result for that date

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Thanks for sharing, Anonymous.

     

     

    Best Regards,
    Dale