finding end of quarter date using dax

[uc]

Hello

I am not getting any result for the following dax

End of Quarter = if([2.5 Year Review Due by] = 30/04/2023 || [2.5 Year Review Due By] = 31/05/2023 || [2.5 Year Review Due By] = 30/06/2023, 30/06/2023, blank())

where 2.5 Year Review Due By is a date column with the following dates

30/04/2023

31/05/2023

30/06/2023

Can you help please? Not sure why I am not getting results. Thanks

[uc]

I did thanks

[Ritaf1983]

Hi @uc 
We have Dax function ENDOFQUARTER for this goal :

In your scenario, it can be 

End of Quarter = if(ENDOFQUARTER([2.5 Year Review Due by] = 30/06/2023, 30/06/2023, blank())

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[uc]

Hi Rita

Thanks for your reply. It works :)!

[Ritaf1983 · Accepted solution]

Hi @uc  happy to help , please consider Accepting it as the solution to help the other members find it more quickly