YTD calculation based on Month name

[Varun511]

HI,

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 

[lukiz84 · Accepted solution]

Add a calculated column:

MonthNumber := MONTH("1. " & table[Period])

Then use the measure:

SumOfValuesYTD = 
   CALCULATE(
      SUM(table[Values]), 
      table[MonthNumber] <= SELECTEDVALUE(table[MonthNumber])
  )