Next 3 Month 1st day Calendar

[Avantha]

Hi,

could you please help me on this ?

i wanted to create a 1st day calendar for a next 3 month. I only need the first day of the month. means my table should only have 3 rows.

ex -

1/9/2019

1/10/2019

1/11/2019

Tks

Avantha

[Greg_Deckler · Accepted solution]

Perhpas try something like this in DAX:

Table = 
VAR __today = TODAY()
VAR __month = MONTH(__today)
VAR __year = YEAR(__today)
VAR __month1 = IF(__month = 12,1,__month+1)
VAR __year1 = IF(__month = 12,__year+1,__year)
VAR __date1 = DATE(__year1,__month1,1)
VAR __month2 = SWITCH(__month,11,1,12,2,__month+2)
VAR __year2 = IF(__month >= 11,__year+1,__year)
VAR __date2 = DATE(__year2,__month2,1)
VAR __month3 = SWITCH(__month,10,1,11,2,12,3,__month+3)
VAR __year3 = IF(__month >= 10,__year+1,__year)
VAR __date3 = DATE(__year3,__month3,1)
RETURN { __date1, __date2, __date3 }

If you want M code, @ImkeF  can probably help.

[Avantha]

It works, thanks a million