Forum Discussion
drill though help
Hi This is my main values I want to use to drilldown to a sub-page (image a). My sub-page(drill through page) isnt recognising this format as this field is originally in a date format i.e. '31/1...
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
Have you tried to see if it works? I would expect year/month to pass through a set of dates for that period.
of course I have 🙂