How to create calender in report ?

[Yulius]

please help me, i want to create calender in power bi report. Nothing could provide a way to create a calendar in power report bi?

thanks 

[tringuyenminh92 · Accepted solution]

Hi @Yulius,

To show current Month and Year of your data, you could create Calculated Measure:  Current Month Year = Max(DateColumn).Month or Format(maxdateMeasure)

Current Month Year = MAX(DimDate[FullDateAlternateKey])

or

Current Month Year with format = FORMAT( MAX(DimDate[FullDateAlternateKey]),"MMMM, yyyy")

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen

[tringuyenminh92 · Accepted solution]

Hi @Yulius,

To show current Month and Year of your data, you could create Calculated Measure:  Current Month Year = Max(DateColumn).Month or Format(maxdateMeasure)

Current Month Year = MAX(DimDate[FullDateAlternateKey])

or

Current Month Year with format = FORMAT( MAX(DimDate[FullDateAlternateKey]),"MMMM, yyyy")

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen

[Yulius]

hi @tringuyenminh92,

thanks for replay and formula .

btw, you create new table calender ?

how to create new table format in there. please tell me or you have a reference to it.

Thanks 

[tringuyenminh92 · Accepted solution]

Hi @Yulius,

If you are using import mode, you could choose Modeling tab -> New table->

 TableDatesName= Calendarauto() 

or

 TableDatesName= Calendar(fromdate,todate)

(fromdate, todate could be created by Date(Year,Month,Day))