Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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))
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
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
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))