topic Replacing months by numbers in DAX Commands and Tips

Replacing months by numbers

TiaCamilian — Mon, 18 Nov 2019 21:54:30 GMT

Hi,

I need to replace the Year-Month with a value like Month1, Month2 etc...

I need to put __Total next 11 months and __Total 12 months back togeter

I need the data in the following format:

Can someone help me understad how I make this change to the date column

I am using:

__MonthNo1 = SWITCH(HireVihecle[__FormathMonth],

"January", -1,

"February", 2,

"March", 3,

"April", 4,

"May", 5,

"June", 6,

"July", 7,

"August", 8,

"September", 9,

"October", 10,

"November", 11,

"December", 12

)

But I am getting differemnt numbers:

1 = 2056

2 = 5262

3 = 11169

Why am I getting these numbers and not just the 1, 2, 3 etc...

nhoward — Tue, 19 Nov 2019 01:40:16 GMT

Assuming that your field _Date11 is formatted as date, and that you are happy that Jan = 1 and Feb = 2

MonthNo = MONTH(LASTDATE(table[_Date11]))

Anonymous — Tue, 19 Nov 2019 04:45:34 GMT

TiaCamilian
I guess the numbers are getting summarized. Just select the visual and right click on the __MonthNo1 field and select Don't summarize

TiaCamilian — Tue, 19 Nov 2019 15:12:12 GMT

Yes it was counting. Now is working.

Thank you