Forum Discussion
cristianml
4 years agoPost Prodigy
Create Column with SUMIF
Hi,
I'm trying to cerate a column like a SUMIF of NWD value depending or grouping by FY&Q column.
The column should show these numbers
Thanks
Hi cristianml ,
Does this work for you?
TomsColumn = CALCULATE ( SUM ( NWD_Table[NWD] ), ALLEXCEPT ( NWD_Table, NWD_Table[FY & Q] ) )
/Tom
https://www.instagram.com/tackytechtom
1 Reply
- tackytechtomMost Valuable Professional
Hi cristianml ,
Does this work for you?
TomsColumn = CALCULATE ( SUM ( NWD_Table[NWD] ), ALLEXCEPT ( NWD_Table, NWD_Table[FY & Q] ) )
/Tom
https://www.instagram.com/tackytechtom