Power pivot Calculated column skipping top 'row' .

[Dicken]

Hello,

I have a in power pivot I was doing a calculated column running total and the results are correct but wrong 'row'.
the first row is blank and the everything is shifted down one. answer for row 1 in 2 , 2 in 3 etc.

I tried both EARLIER and a variable but both the same, I can't see anything wrong with the first date?

I've made a copy and attached it , its the pTaverage tab.

RD

[oeldere]

You did added the expected result manualy in the file.

In which cells your want a change, since that is not clear to me based on the excel file.




And I don't see the Power Query data (of am I missing something)?

I found them, my mistake.

[XOR LX]

Hi again,

But of course. You're using

<nowdate

as your condition, but that should be

<=nowdate

Regards

[Dicken]

There isn't any power query data it's pivot.

RD

[Dicken]

Thank you.
I'm going to blame it on the fact that I've been plugging away at 'ALLSELECTED' and my brains gone numb.

Richard.

[XOR LX]

I'm going to blame it on the fact that I've been plugging away at 'ALLSELECTED' and my brains gone numb.

Yeah, DAX will do that to you after a while!

Cheers