Forum Discussion
Post ProdigyMisterious calendar
How in this example https://www.sqlbi.com/articles/improving-temporal-line-charts-in-power-bi-with-dax/ created calendar? as i cant reproduce same result
as i always getting this **bleep**
6 Replies
- amitchandak
Super User
Analitika , Not very clear. Seem like the Hierarchy name is calendar and the screenshot is of old UI.
- Analitika
So how to get same calendar?
or read data in power query editor without password
or create same chart
- amitchandak
Analitika , They have given a couple of formula's how to create, you can try
if you need in power query
refer
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-2-fiscal-columns
for Dax Refer :radacad sqlbi My Video Series
Appreciate your Kudos.
- FrankAT
Community Champion
Hi Analitika
this calendar hierarchie was created by power bi desktop automatically. You can avoid this mechanism if you deselect the checkboxes (see figure). Create your own hierarchie.
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
