Forum Discussion

ph's avatar
ph
Icon for Helper I rankHelper I
7 years ago
Solved

DAX - get value from measure

Hi all, I am beginner and I was wondering if somebody can help me with following problem   I have measure (Amount) that is for each date different, and I want get actual value for today.. logical...
  • Cmcmahan's avatar
    Cmcmahan
    7 years ago

    Sure. Since you already have a measure for [Amount], you can just calculate it with a new context. 

    AmountToday = CALCULATE( [Amount], Table[Date] = TODAY())

     

    If this doesn't work, can you share your current code for [Amount]?

Cmcmahan's avatar
Cmcmahan
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Sure. Since you already have a measure for [Amount], you can just calculate it with a new context. 

AmountToday = CALCULATE( [Amount], Table[Date] = TODAY())

 

If this doesn't work, can you share your current code for [Amount]?