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.
Ashish_Mathur
Super User
Super UserHi,
This is another column you have created in the Calendar Table. Since the Date column stays intact and that is the column you hae built the relationship to, all measures and columns will work as expected.
Thank you Ashish for your time and inputs.
- Ashish_Mathur
You are welcome.