Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.