Forum Discussion
Solved
Importing date - year only
I'm working with the BP energy report. For date it provides year only. How do I get this recognised as a date when I am importing ti to PowerBI? Currently I am creating another column = "1/1/" and...
Hey LoxleyLearner ,
this pattern Budget – DAX Patterns contains, some techniques to model different granularities.
Besides that, there is no way that is more elegant.
Regards,
Tom
LoxleyLearner , Not very clear , you can date with year like
date = date([year],1,1)
You can join with date table if needed
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.