Forum Discussion
bhmiller89
Helper V
Helper VAdding 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
- Greg_Deckler
Community Champion
In DAX that would be:
Column = DATE(2019,1,1)
- Greg_Deckler
In Power Query:
Date.FromText("2019-1-1")