Forum Discussion

Yulius's avatar
Yulius
Frequent Visitor
9 years ago
Solved

How to create calender in report ?

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 
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    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's avatar
    tringuyenminh92
    9 years ago

    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))

Yulius's avatar
Yulius
Frequent Visitor
9 years ago

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's avatar
tringuyenminh92
Memorable Member
9 years ago

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))