Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, guys
I created a table via CalenderDate = CALENDAR(DATE(2019, 01, 01), DATE(2020, 12, 31))
Solved! Go to Solution.
Hi @Anonymous
Hopefully, this article will help you to understand what [Date].[Date] is
https://www.sqlbi.com/articles/automatic-time-intelligence-in-power-bi/
In your example, max2 is returning a max of all dates in automatic date/time table as Month column is in another table that is not propagating the filter down to auto date table.
If you have a date dimension in your model best practice is to switch off automatic date/time and not use it.
Hi @Anonymous
Hopefully, this article will help you to understand what [Date].[Date] is
https://www.sqlbi.com/articles/automatic-time-intelligence-in-power-bi/
In your example, max2 is returning a max of all dates in automatic date/time table as Month column is in another table that is not propagating the filter down to auto date table.
If you have a date dimension in your model best practice is to switch off automatic date/time and not use it.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |