Forum Discussion

Varun511's avatar
Varun511
Icon for Helper I rankHelper I
3 years ago
Solved

YTD calculation based on Month name

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 function...
Need Help
  • lukiz84's avatar
    lukiz84
    3 years ago

    Add a calculated column:

     

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

     

    Then use the measure:

     

    SumOfValuesYTD = 
   CALCULATE(
      SUM(table[Values]), 
      table[MonthNumber] <= SELECTEDVALUE(table[MonthNumber])
  )
lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable Member
3 years ago

Add a calculated column:

 

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

 

Then use the measure:

 

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