Forum Discussion
Date Issues in Visuals
- 1 year ago
ArchStanton - Have you tried using an inactive relationship between "Resolution Date" and then creating a special measure for this visual that leverages USERELATIONSHIP( ) to activate the relationship?
Here's some guidance on the use of this DAX function: https://dax.guide/userelationship/
If this doesnt work, it could also be more simple, and to do with the fact you're using a fiscal / financial month ordering with a calendar year. An additional column in your calendar that presents the fiscal / financial year could resolve this.
Here is an example of some M Code I use to create a fiscal / financial year column
InsertFYStart = Table.AddColumn(InsertWeekOfYear, "FYStart", each if [Month Number] <= 3 then Date.FromText(Number.ToText(Date.Year([Date])-1) & "-04-01") else Date.FromText(Number.ToText(Date.Year([Date])) & "-04-01"),type date), InsertFinancialYear = Table.AddColumn(InsertFYStart, "FinancialYear", each Number.ToText(Date.Year([FYStart]))&"/"& Text.End(Text.From(Date.Year([FYStart]) +1), 2)),If this helps guide you towards a fix, please accept as the solution, which will help others with the same challenge.
- 1 year ago
ArchStanton - For this I would enable the preview features show below:
And then edit your measures as one using VS Code - there's some great guidance on getting started with that in this video: https://www.youtube.com/watch?v=TPASF4HlEOA
Ps also, I have dozens of measures that will need to be updated with USERELATIONSHIP which will cost me a lot of time - i don't suppose there is a quick way of updating these If I decide to go down your route in future is there?
ArchStanton - For this I would enable the preview features show below:
And then edit your measures as one using VS Code - there's some great guidance on getting started with that in this video: https://www.youtube.com/watch?v=TPASF4HlEOA