I use the following expression in Power BI,
"DATESINPERIOD(cashserv[date], LASTDATE(cashserv[date]), -365, DAY) and it works fine. "
When I try to use it in Power Pivot Measure is gets syntax error
"The expression is not valid or appears to be incomplete. Please review and correct the expression.
The syntax for 'day' is incorrect. (DAX(DATESINPERIOD(cashserv[date],LASTDATE(cashserv[date]),-365, day)"
Can someone help me with this?
Thanks.
"DATESINPERIOD(cashserv[date], LASTDATE(cashserv[date]), -365, DAY) and it works fine. "
When I try to use it in Power Pivot Measure is gets syntax error
"The expression is not valid or appears to be incomplete. Please review and correct the expression.
The syntax for 'day' is incorrect. (DAX(DATESINPERIOD(cashserv[date],LASTDATE(cashserv[date]),-365, day)"
Can someone help me with this?
Thanks.