Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Difference between last - current month results

Dear Power BI users,

 

I'm relatively new to Power BI and am trying to learn as much as I can. Sadly im running into an issue.

Im trying to create a column that compares current month customers to last month. It should look something like this:

 

MonthYear       Customers         Difference

09-2018             400                     20

08-2018             380                     -10

07-2018             390                      -50 etc.

 

I've tried numerous helpful tips from the forums and it resulted in nothing. 

So far I've created a seperate measure for total amount of customers and used different formulas. No luck.

Am I overthinking things?

 

I would greatly appreciate a word of advice to advance further :) If there is any additional information you might need, let me know.

 

Kind regards,

Daniël

1 Reply

  • JosefPrakljacic's avatar
    JosefPrakljacic
    Solution Sage
    6 years ago

    Hey,

     

    I would recommend that you have a propper data table in place.

    Then I would use a combination of the functions CALCULATE and PreviousMonth in order to achive your desired result.

     

    YourMeasure := CALCUALTE(CustomersCount,DATESBETWEEN(FIRSTDATE(TODAY),LASTDATE(TODAY)) -CALCULATE(CustomersCount,PREVIOUSMONTH(TODAY()))

     

    Please don't forget to give a 👍 and accept the post as solution. (If it helped 😅)
    Have a nice day!

    BR,
    Josef
    Graz - Austria