Forum Discussion
KW123
Helper V
Helper VPrevious Month
Hi, I need to get the MAX (or last value) of a previous month for a measure [WhatdoesYTDtotalneedtobe] I have tried using this DAX as both a measure and a column, but it only returns blanks. ...
KW123Helper V
Helper VI created a column which shows me the last day of the previous month:
Last day of previous month =
PREVIOUSMONTH('Dates'[Last day of month])
However when I try to use it in a calculate measure this is the error:
A Function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.'
The DAX I am using:
However when I try to use it in a calculate measure this is the error:
A Function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.'
The DAX I am using:
Lastdayprevmonthvalue =
CALCULATE([What does YTD total need to be],'2022 Goals'[Last day of previous month])