Forum Discussion

thems5's avatar
thems5
Regular Visitor
8 years ago

Power BI measure

Hi, I wish to measure the percentage of the difference between each period to period before. I am trying to create this report using Power BI for the first time. When I was using an Excel pivot ta...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Moshe,

 

Just based on your data here, please try the formula below.

Measure =
VAR thisYearTotal =
    SUM ( 'DB_sample'[Sales] )
VAR lastYearTotal =
    CALCULATE (
        SUM ( 'DB_sample'[Sales] ),
        FILTER (
            ALL ( DB_sample[Year] ),
            DB_sample[Year]
                = MIN ( DB_sample[Year] ) - 1
        )
    )
RETURN
    DIVIDE ( thisYearTotal - lastYearTotal, lastYearTotal, 0 )

Best Regards,

Dale

thems5's avatar
thems5
Regular Visitor
8 years ago

 

 

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

    Hi thems5,

     

    Can you share your file? Please refer to the snapshot below. Double click the menu "Modeling".

    Power_BI_measure

     

    Best Regards,

    Dale

    • thems5's avatar
      thems5
      Regular Visitor
      8 years ago

      Thank you.

      I cannot find the way to attach a file here so I attached it in my email reply.

      Regards

      Moshe