Forum Discussion

hdsogno's avatar
hdsogno
Helper I
6 years ago
Solved

Calculating Period over Period

Hi All - Having trouble calculating percentage difference between periods.  I have 2 tables, 1 with Dates and 1 with Product data, Customers and Dates.  In the report are 1 Slicer for months and 1 Ma...
  • amitchandak's avatar
    amitchandak
    6 years ago

    hdsogno , this will come by time intelligence using this year vs last and their diff. Power Bi do not have column diff.

     

    Can you share actual data on which you need this, make me @

hdsogno's avatar
hdsogno
Helper I
6 years ago

Thanks for the reply but not what I'm looking for.  I have a date table already.  What I'm looking for is a calculation for the percent difference to produce results like this:

 

                 2019           2020          % Dif

Bolts            4                 4                0%

Nuts            2                 5             150%

Screws        6                 5             - 16%

Total           8                 9                12%

amitchandak's avatar
amitchandak
Super User
6 years ago

hdsogno , this will come by time intelligence using this year vs last and their diff. Power Bi do not have column diff.

 

Can you share actual data on which you need this, make me @

  • hdsogno's avatar
    hdsogno
    Helper I
    6 years ago

    amitchandak - There was something wrong with my date table.  I fixed it and your solution did work.

     

    Thank you.