Forum Discussion
Anonymous
2 years agoNot applicable
Conditional Formatting Dax
I know there is a lot of stuff out there about this but I have been going at it for ages and still can't figure it out. I am trying to compare each months count with the previous month. I want to co...
Anonymous
2 years agoNot applicable
Thank you for your repsonse! I am still getting the same output as before.
I have created a column in my date table with Current Month Offset as that is what I thought you did above.
And this is my new measure:
Do you know why this is happeneing?
Alex87
2 years agoSolution Sage
You need to use a proper date calendar. the Month offset you created is not good.
I recommend using Melissa's PQ date table, by far the most adanced calendar table out there.
Extended Date Table (Power Query M function) - Power Query / M Code Showcase - Enterprise DNA Forum
For info, my month offset looks like this: