Dax Function to label Date from Date 1- 15, the label is end of month

[adityo]

Hi Power BI Masters

i need DAX to make a date like this, when the date is from 1 - 15, the date will be end of month this date, but when 16 -31 the date will be the next 15 in the next month, for example like this :

Date
1 March 2023 --> 31 March 2023

3 March 2023 --> 31 March 2023

10 March 2023 --> 31 March 2023

14 March 2023 --> 31 March 2023

15 March 2023 --> 31 March 2023

16 March 2023 --> 15 April 2023

20 March 2023 --> 15 April 2023
30 March 2023 --> 15 April 2023

31 March 2023 --> 15 April 2023

1 April 2023--> 30 April 2023

[aditya0125]

Try this one

[ValtteriN · Accepted solution]

Hi,

Here is one way to do this:

15 or EOMONTH =

var _date = MAX('Calendar'[Date])

 var _year = YEAR(MAX('Calendar'[Date]))

 var _month = MONTH(MAX('Calendar'[Date]))

 return

IF(DAY(_date)<16, EOMONTH(_date,0),DATE(_year,_month+1,15))

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/