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 functions 

 

any  help highly appreciated 

 

 

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])
  )

1 Reply

  • 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])
  )