Forum Discussion
Foxxon28
Helper I
Helper ICumulative Sales Sum based on Specific Column and Rule
Dear reader, I have a dataset as follows: Year Date ( Once Per Month ) Month_progress Sales 2024 30-11-2023 -1 10 2024 31-12-2023 0 20 2024 31-01-2024 1 30 2023 30...
Foxxon28 PBIX is attached below signature.
Sales Measure = VAR __MP = MAX('Table'[Month_progress]) VAR __Year = MAX('Table'[Year]) VAR __Table = FILTER(ALL('Table'), [Month_progress] <= __MP && [Year] = __Year) VAR __Result = SUMX(__Table, [Sales]) RETURN __Result
Greg_Deckler
Community Champion
Community Champion
Foxxon28Greg_Deckler I've tried a few things, but have yet to come up with a working measure. Could you help me out here with my given date sample.
Would like to hear from you.
Daniël
- Greg_Deckler
Foxxon28 PBIX is attached below signature.
Sales Measure = VAR __MP = MAX('Table'[Month_progress]) VAR __Year = MAX('Table'[Year]) VAR __Table = FILTER(ALL('Table'), [Month_progress] <= __MP && [Year] = __Year) VAR __Result = SUMX(__Table, [Sales]) RETURN __Result