Forum Discussion
Index column in calculated table
Hello, guys! Created dynamic date scales https://www.inkeysolutions.com/blogs/power-bi-dynamic-scales-values/ and got the problem. The x-axis sorted in a wrong way I created an "inde...
So, the solution is.
add adition column via union - formulae below. (Calendar[Current date] - measure)
UNION(
SUMMARIZE ('Calendar', 'Calendar'[Month&Year], "Frequency", "Monthly", "Sorting", 'Calendar'[Current date]),
SUMMARIZE ( 'Calendar', 'Calendar'[Quarter&Year], "Frequency", "Quarterly", "Sorting", 'Calendar'[Current date]),
SUMMARIZE ( 'Calendar', 'Calendar'[Year], "Frequency", "Yearly", "Sorting", 'Calendar'[Current date])
)
and Sort by Sorting column.
Thanks sayaliredij for idea.
SOLVED