Forum Discussion
DATEADD Syntax error DAX argument separator comma semicolon
Hi All, I am having an annoying issue with DATEADD syntax, specifically with the "Interval" term. The syntax of DATEADD is DATEADD(DimDate[DateKey], Number of Intervals, Interval) Where for int...
v-sihou-msft
Microsoft Employee
Microsoft Employee
In Power BI, it only accepts comma as separator. Currently you have to replace all semicolon into comma. You can submit a feature request on Idea.
However, in this scenario, since you want to return the previous month date based on row level data, you should create a calculated column instead of measure. Otherwise it will still throw error like below:
It should work by using calculated column, and it will prompt interval automatically when you input last comma.