Hi,
Cross questioned excel forum ;
I have been using the following in power pivot to create a running total;
but when i try using this in power bi I just get the 'row' value? I have got it to work by adding an index column, so it's just the date that it doesn't recognize, I tried creating a calendar table using calendarauto which I linked but didn't make any difference.
Cross questioned excel forum ;
Power Bi running total and power pivot [SOLVED]
Hello, Also asked on Mr Excel ; https://www.mrexcel.com/board/threads/running-total-measure-in-power-bi.1210134/ I have running total formula whch works perfectly well in power pivot but I can't get it to work in power bi, which I'm trying to get to grips with, RTM:=VAR mdate =...
www.excelforum.com
Excel Formula:
CALCULATE ( [total sales ], FILTER (ALL( TABLE [DATE ] ) , TABLE [DATE] < = MAX(TABLE [ DATE ] ) )but when i try using this in power bi I just get the 'row' value? I have got it to work by adding an index column, so it's just the date that it doesn't recognize, I tried creating a calendar table using calendarauto which I linked but didn't make any difference.
Last edited by a moderator:
