Importing date - year only

[LoxleyLearner]

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?

[amitchandak]

@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.

[TomMartens · Accepted solution]

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