Forum Discussion
Solved
Cumulative Totals showing same value for each row
Hi all, I hope this is not a basic question, but I am new to PowerBI, and I've been looking for a long time with no solutions here. My problem is as follows: I have a number of accounts (10 or...
You are seeing this behaviour because you are using Today() in your MaxDate variable. You are effectively using the same date for every column which is why you are seeing the same value in every row.
I think if you change this to the following your calc should work:
VAR MaxDate = MAX( 'PostGL'[txDate] )
d_gosbell
Super User
Super UserYou are seeing this behaviour because you are using Today() in your MaxDate variable. You are effectively using the same date for every column which is why you are seeing the same value in every row.
I think if you change this to the following your calc should work:
VAR MaxDate = MAX( 'PostGL'[txDate] )
Thank you so much! This fixed it