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...
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi inesj 

Create measures: 

Min Start Date =
CALCULATE (
    MIN ( Contracts[Contract Start Date] ),
    ALLSELECTED ( Contracts[Contract] ),
    ALL ( Contracts )
)
End Start Date =
CALCULATE (
    MAX ( Contracts[Contract End Date] ),
    ALLSELECTED ( Contracts[Contract] ),
    ALL ( Contracts )
)

If this doesn't work please share the pbix (with dummy data if necessary) that reproduces the issue

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers