Forum Discussion
cristianml
Post Prodigy
Post ProdigyDAX 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
- ImkeF
Community Champion
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.
cristianml- ImkeF
Looks like you're missing the underscore (RT_Actual)