Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.