Forum Discussion

montiell's avatar
montiell
New Member
5 years ago

Extract date from a column with date time

Hello team,   I am practically still new with power bi dax formulas and I am trying to accomplish to create a new colum or date hirearchy. My current colum data is format as follow:   11/26/2020 ...
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi montiell 

Completed-MonthYear = DATEVALUE( [DATACOLUMN] )

or

Completed-MonthYear = INT( [DATACOLUMN] )

 then convert the column to date  and choose the format you prefer

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers