Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cummulative sum using a different dataset date field

I have two datasets here i have one Amount field and one date field in each dataset. I have created two measures which gives me the cummulative sum in each dataset.   Table1: Date Amount Cumm...
Need Help
Show and Tell
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    you need a date table with relations to both tables.

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi Anonymous ,

 

you need a date table with relations to both tables.

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.