I am trying to automate my current and Prior Week calculations for my table. I am having trouble with the Prior Week based measures and I think it is due to some kind of formatting. [This is my Current Week Calculation] (https://i.sstatic.net/0x9aWfCY.png)
and this is my [Prior Week Calculation]
(https://i.sstatic.net/CJLUePrk.png)
I have also tried PW=Calculate(Table[CW]-1
The Prior week calculation was working before I automated the Current Week measure, and both Formats are set to Whole Number. One other note when I change Prior Week to 15, for example, all the other measures work fine.
Any Ideas on what I am doing wrong?
I am expecting a number value that can be used in the other measures.
Cqueen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.