Forum Discussion
cristianml
Post Prodigy
Post ProdigyCreate 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
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi 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