Forum Discussion
Measure Total not adding correctly in table
Hi community, hoping you can assist, my total in a table is not adding up correctly. All the row/line amounts are correct based on the below DAX. However, i believe the total is adding up v...
This does not work?
IF(MONTH([Selected To Date]) = 7, 0, calculate(TOTALYTD(SUM('GL History Periods'[glhp_amount]), 'Calendar'[date], FILTER('Calendar', 'Calendar'[date] <= [EoMSD]), "6/30") , type='N')- [Movement])
Hi Gabry , tried but it did not like the syntax