Forum Discussion
Change Date format to YYYYMM
Hi, I have a date column in YYYYMMDD format, when I import to Power BI, the Data Type is Text. I need to convert to Data Type "Date" and Date Format -> YYYYMM. In the Modeling tab, the D...
Hi,
In the Date Table, write this calculated column formula
=FORMAT('Date'[Date],"YYYYMM")
In the slier, drag this column.
Hope this helps.
Thank you Ashish for your time and inputs.
Ashish_Mathur
Super User
Super UserYou are welcome.