Forum Discussion

kylee_anne's avatar
kylee_anne
Icon for Helper II rankHelper II
1 year ago
Solved

Calculate using date filter

Hi,   I'm trying to this: But I can't and don't understand why.   I'm trying to sum to a certain reporting date which changes and so can't be hard coded. This is the DAX I have for it: ...
Need Help
  • Uzi2019's avatar
    Uzi2019
    1 year ago

    Hi kylee_anne 

     

    Try this,

     

    Calculate( Sum ( Sales), Filter ( 'Table', 'Table'[Date]= Max( 'Table'[Date]))

     

    I hope I answered your question!

     

     

Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
1 year ago

Hi kylee_anne 

 

Try this,

 

Calculate( Sum ( Sales), Filter ( 'Table', 'Table'[Date]= Max( 'Table'[Date]))

 

I hope I answered your question!