Hello- I am new to Power BI & DAX. I am struggling to work out how to return lowest date across two tables.
I want the following rules applied
If deceased date blank then end date
If deceased date before end date- deceased date
All else end date
Format Looks like Below
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I want the following rules applied
If deceased date blank then end date
If deceased date before end date- deceased date
All else end date
Format Looks like Below
<colgroup><col><col span="2"><col><col span="2"><col><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Appreciate your help! SJ | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>