Forum Discussion

K_Hermann's avatar
K_Hermann
Regular Visitor
8 years ago
Solved

Months in wrong order

Hello, I need help with a subject. I have a few KPI's which are numbers, a target which is a number and the months. If I make a cauge I can select the current month, july. But if I make a KPI...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Open the attached file. I created a dummy table "Sales", then created the Calendar table like I told you, then created the relationship and you'll see the date hierarchy on the Calendar Table.

     

    https://www.dropbox.com/s/xhj8oz54j1agp6k/Sample.pbix?dl=0

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Calender = CALENDAR(FIRSTDATE('FactTable'[Date]);LASTDATE(FactTable'[Date]))

Change the name of table and column. This way you have a dynamic Calendar Table always depending on Fact table, which is the recommended way.

K_Hermann's avatar
K_Hermann
Regular Visitor
8 years ago

I only get errors. This is my data. So what do I need to fill in after FIRSTDATE(. Because I get errors if I fill in dates like 1, 8, 2018 and I get errors if I fill in Juni, 2018. So I don't get it. Do I need to make other tables in excel first?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Open the attached file. I created a dummy table "Sales", then created the Calendar table like I told you, then created the relationship and you'll see the date hierarchy on the Calendar Table.

     

    https://www.dropbox.com/s/xhj8oz54j1agp6k/Sample.pbix?dl=0

  • K_Hermann's avatar
    K_Hermann
    Regular Visitor
    8 years ago

    Yes! Thank you so much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Does it work for you?