Forum Discussion
Solved
Offset Month Calculated Column
Hi, I have a column named 'Month' which just has the dates of the 1st day of each month (see below) The MAX month as you can see is Sep 2022. I would like to create a calculated col...
Try this calculated column in the table DimDate:
Offset Month = VAR vToday = TODAY () VAR vResult = DATEDIFF ( vToday, DimDate[Date], MONTH ) + 1 RETURN vResult
Ah hah. That did the trick. I am still new to Power BI, so still much to learn. Thank you!
No problem