Forum Discussion
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 then merging this with the BP date (for example of 1975) creating 1/1/1975 which I can then allocate a date status to. But I'm sure that there must be a better more professional way of accomplishing this - can you tell me this please?
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
2 Replies
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.
