Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cumulative graph value on specific date

Hi guys. Is it possible to get a value for a specific date from a cumulative graph and put that in a card or taco visual for example?   I cannot currently do it as the measure for the cumulative gr...
power bi
  • Andre_Jaar's avatar
    Andre_Jaar
    6 years ago

    Sure...

     

    Measure = 
      VAR DateYouWant = DATE(2020,5,1)  // Or...a MAX() of any table, you choose

    RETURN
      CALCULATE( [measureyouwant] , FILTER( ALL( CalendarTable ) , CalendarTable[Date] <= DateYouWant) )

Andre_Jaar's avatar
Andre_Jaar
Frequent Visitor
6 years ago

Sure...

 

Measure = 
  VAR DateYouWant = DATE(2020,5,1)  // Or...a MAX() of any table, you choose

RETURN
  CALCULATE( [measureyouwant] , FILTER( ALL( CalendarTable ) , CalendarTable[Date] <= DateYouWant) )