Forum Discussion
Solved
DAX Formula not working in PQ
Hi,
The following formula is not working in PQ:
= PREVIOUSMONTH('List Period Table'[Date - Period])
return
CALCULATE(AVERAGE('RT_Actual'[Quantity]), 'RT Actual'[Category]="Cost Rate", refMonth)
Looks like you're missing the underscore (RT_Actual)
4 Replies
Hi cristianml ,
it seems that you've missed the start of your formula.
Just add "VAR refMonth = " in front of it and it should work.
Looks like you're missing the underscore (RT_Actual)
