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.
Hello,
I am in Direct Query mode.
for each date, a column for year, quarter, and month was created in the database. This was done for practical reasons, as a user will want to display information by month or year for different dates in a table vizual.
I do not understand the usefulness of having a calendardate table in this case.
Thank you for your explanations.
best regards
Solved! Go to Solution.
All Time Intelligence functions require a contiguous and covering calendar table that ideally is marked as a Date table. This table is usually very small, so its impact on your data model is minimal. It is highly recommended that each of your data models includes that table.
All Time Intelligence functions require a contiguous and covering calendar table that ideally is marked as a Date table. This table is usually very small, so its impact on your data model is minimal. It is highly recommended that each of your data models includes that table.
Thank your for your reponses.
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.
User | Count |
---|---|
109 | |
105 | |
88 | |
75 | |
67 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |