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.
Hello, I am probably blind, but cannot find a way how to set the following. 😕
I am using Time intelligence function within date format column. The hierarchy is created in order: Year, Quarter, Month, Day. Which is generaly correct.
However, I need in its final "stage" get all the days of all the months (and quarter or years) - like 01.04.2021, 02.04.2021, ... 22.12.2021, 23.12.2021,...
With specific date of all days. Instead of just days (as 1 to x).
Thank you very much in advance for any help. 🙂
Solved! Go to Solution.
Hi @Anonymous ,
You need to create a date table. For example.
Please create a new table.
date_table = CALENDAR(MIN('Table'[cal_eop]),MAX('Table'[cal_eop]))
You will get a table with consecutive date columns from [cal_eop] column minimum date to maximum date. It is common practice to apply this table as a date table in relations and calculations.
Please refer to these for ideas.
[Data Modeling] Three Ways to Create a Calendar Ta...
Creating a simple date table in DAX
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @Anonymous ,
You need to create a date table. For example.
Please create a new table.
date_table = CALENDAR(MIN('Table'[cal_eop]),MAX('Table'[cal_eop]))
You will get a table with consecutive date columns from [cal_eop] column minimum date to maximum date. It is common practice to apply this table as a date table in relations and calculations.
Please refer to these for ideas.
[Data Modeling] Three Ways to Create a Calendar Ta...
Creating a simple date table in DAX
Best Regards,
Community Support Team_Gao
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @Ashish_Mathur,
thank you, I have no calendar table actually. Only one column with all dates and the hierarchy is created by power bi time intel. function "under" this column (img bellow, sorry for non-english naming). I tried drag that column (within visual too) but nothing is happening, as the hierarchy is created from it (I guess).
Hi,
You must create a Calendar Table via the Calendar function.
Hi,
From the Calendar Table, just drag the Date column.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |