Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Cumulative for Filtered Period

Hi All   I've got the issue where I want my data visuals to be dynamic to the dates but for some reason it's still cumulating data from the previous dates.   For example, I have a data set that s...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Create your measure using dax below.

    Cumulative Spend =TOTALYTD(SUM(SUM ( [Amount (Excl VAT)] ), 'Vendor Ledger'[Document Date].[Date], 'Vendor Ledger'[Document Date].[Date]<=TODAY())



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Create your measure using dax below.

Cumulative Spend =TOTALYTD(SUM(SUM ( [Amount (Excl VAT)] ), 'Vendor Ledger'[Document Date].[Date], 'Vendor Ledger'[Document Date].[Date]<=TODAY())



Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks Lydia!

 

I took out one of the SUMs and it worked a treat!