Forum Discussion
Solved
Adding a Static Date as a Custom Column
I have different data tables representing data for different YearMonth combos. I need to add a column to each table with the appropriate YearMonth. For example, I want a column where every record says "1/1/2019"
How would I write this in the "Add Custom Column" box ?
In DAX that would be:
Column = DATE(2019,1,1)
2 Replies
In DAX that would be:
Column = DATE(2019,1,1)
In Power Query:
Date.FromText("2019-1-1")