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 |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |