Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I know there are heaps of similar posts and I promise I've tried different solutions, but for the life of me, I can't work out what I'm doing wrong.
I'm attempting to calculate the increase in median price over 20 years. The data will be updated quarterly, so I need to use dynamic dates.
The calc works fine in as far as I can get results and graph it, but the moment I try to apply filters to the visual in any way, I get the 'DATE' has the wrong data type error displaying in the visual.
Solved! Go to Solution.
@HChoice , I am assuming Quarter Ending has datatype date and if so measure looks correct.
Need to check what you are adding to visual, because max will work on row context
you can try
VAR mdate = MAXX(allselected('Quarterly Rent') , 'Quarterly Rent'[Quarter Ending])
@HChoice , I am assuming Quarter Ending has datatype date and if so measure looks correct.
Need to check what you are adding to visual, because max will work on row context
you can try
VAR mdate = MAXX(allselected('Quarterly Rent') , 'Quarterly Rent'[Quarter Ending])
Thank you!! Sorry for the exceptionally late reply. I'm not entirely sure why it works, but I'll take it.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |