Forum Discussion
drill though help
If it doesn't then I think you need a separate date table which will give you more control.
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
Do you want to share a demo pbix file and I'll send a working example back.
I normally have a column with a start of month date in it for each date and format that as month year. Order is then taken care of.
Hi
Sorry but i have joined a new organistion so i don't have access to the file . Thank you-i am sure i was misinterpreting something
Community ChampionDo you want to share a demo pbix file and I'll send a working example back.
I normally have a column with a start of month date in it for each date and format that as month year. Order is then taken care of.
Hi
Sorry but i have joined a new organistion so i don't have access to the file . Thank you-i am sure i was misinterpreting something