The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a table with different dates in it : 01/04/2020 and 01/05/2020. I need to create a table of all the dates in the months of the before mentioned date. So first I need to get the distinct months and then I need to get all the dates in those months. Is this possible to do in DirectQuery mode please? Thanks
Solved! Go to Solution.
Hi @Anonymous ,
Try to use below dax expression to create a new table:
New Table= CALENDAR(MIN('table'[date]),MAX('table'[date]))
Hi @Anonymous ,
Try to use below dax expression to create a new table:
New Table= CALENDAR(MIN('table'[date]),MAX('table'[date]))
@Anonymous , you create using a calendar, That will convert it into the mixed mode.
You can have one in the database and mark it as date table here.
refer
Or
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
CALENDAR
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |