Forum Discussion
Solved
Help with If statement (I think) please
Hello, I was hoping someone could help please I have two tables and a due date for a record. The record is in both tables. I would like to present ther record in one visual with one of the two du...
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file whether it suits your requirement.
Record measure: = IF ( HASONEVALUE ( 'ID'[ID] ), MIN ( MAX ( 'Table One'[Date one] ), MAX ( 'Table Two'[Date two] ) ) )
