Forum Discussion

LearningStill's avatar
LearningStill
New Member
3 years ago

Help With Date Formatting

Hello,   I was hoping to get some help regarding changing data type for one of my columns in PowerBI to a date data type. I am using the Data view to do this. As you can see in the screen caps belo...
Need Help
Tutorial Requests
Arul's avatar
Arul
Super User
3 years ago

LearningStill ,

As far as based on my experience we cannot convert whole number into date but you can try the below formula in new calculated column and use it in modelling.

Date = 
VAR _year = LEFT('Table (3)'[month_date_yyyymm],4)
VAR _month = RIGHT('Table (3)'[month_date_yyyymm],2)
VAR _yearMonth = _year &"-"& _month
RETURN _yearMonth

Thanks,

Arul