I have a table with a column of Month NUmber and a column for Year. I want to make a date column for the 1st of the month. The new column I want to be formatted [Month Number]/1/[Year]
Example: the second row is February 2021. I want the new date column to look like 2/1/2021.
Go to Solution.
@DSwezey this was to be done in PQ.
For DAX use this
Column = DATE('Table'[Year],'Table'[Month Number],1)
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
View solution in original post
@DSwezey create a new column as
and then format as you wish through DAX
I get this error when adding the custom column.
date <> #date
to (as written by @smpa01 )
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!