lundi 8 novembre 2021

Power BI date condition

I have two date fields "MonthEndDate" and "date" I want a condition to satisfy that if date is less than 15 then take previous month end date and if date is more than 15 then take current month end date. Eg-

|MonthEndDate | date | ResultDate |

6/30/1999 | 7/2/1999 | 6/30/1999

10/31/1999 | 11/1/1999 | 10/31/1999

5/31/2009 | 5/28/2009 | 5/31/2009

Aucun commentaire:

Enregistrer un commentaire