Forum Discussion

sirramzy's avatar
sirramzy
Frequent Visitor
9 years ago

KPI Measure - Monthly Comparison

Hi All,   Beginner to Power Bi, been using it for a few weeks now. Got a prett basic query.   I'll call my fact table as 'Customer Registration Table' which has the following fields   Registra...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi sirramzy,

Please create a year-month columnm, then add the year-month column as Trend axis. Please see my following screenshot, it shows the expected result.



Best Regards,
Angelia

sirramzy's avatar
sirramzy
Frequent Visitor
9 years ago

v-huizhn-msft and cs_skit

 

I tried using your solutions, and there is an improvement! Only it is showing the MTD and Previous Month count of 2016, instead of 2017

 

I must be doing an elementary mistake somewhere, that i am unable to see. I am attaching the sample for reference. Can you please guide the right way of doing it ?

 

URL : Sample File

 

Regards,

SR

 

  • sirramzy's avatar
    sirramzy
    Frequent Visitor
    9 years ago
    any suggestions please?