Forum Discussion
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
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 NguyenHi 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))
3 Replies
- tringuyenminh92
Memorable Member
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 Nguyenhi 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
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))
