Forum Discussion

inesj's avatar
inesj
Frequent Visitor
5 years ago

Min/Max dates across multiple selected groups

Hi everyone,   I have a report in which the user can see orders information for certain contracts that they can select in a slicer. I have two tables: 1. An "Orders" table, with all the orders in...
amitchandak's avatar
amitchandak
Super User
5 years ago

inesj , Create two measures like

 

Min Start Date = minx(Allselected(Table), Table[Start Date])
End Start Date = maxx(Allselected(Table), Table[End Date])

 

If from contracts, then

Min Start Date = minx(Allselected(contract), contract[Start Date])
End Start Date = maxx(Allselected(contract), contract[End Date])