Have Period column which have Jan to Dec if i select lets say March need to see all my values till march
dont have date column in my dataset in order to use time intelligence functions
any help highly appreciated
Go to Solution.
Add a calculated column:
MonthNumber := MONTH("1. " & table[Period])
Then use the measure:
table[MonthNumber] <= SELECTEDVALUE(table[MonthNumber])
View solution in original post
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.