Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
Hi @sudhir1212 ,
If there's no other condition, you could simple use MAX('table'[date]) to get the maximum date.
If there are other conditions, you could use below formula:
max_date = CALCULATE(MAX('table'[date]),FILTER(ALLSELECTED('table'),condition))
Best Regards,
Jay
Hi @sudhir1212 ,
If there's no other condition, you could simple use MAX('table'[date]) to get the maximum date.
If there are other conditions, you could use below formula:
max_date = CALCULATE(MAX('table'[date]),FILTER(ALLSELECTED('table'),condition))
Best Regards,
Jay
example how to get dates min/max
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Date] >=_min && 'Table'[Date] <=_max))
User | Count |
---|---|
99 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |