Date Function returning wrong Date

Anonymous , Try var day like

var day = Switch(true(),
vw_LoadSummaryINTL[Month] = 2,28,
vw_LoadSummaryINTL[Month] in (4,6,9,11) , 30,
31)

or

Transaction Date =

 eomonth(date(vw_LoadSummaryINTL[Year], vw_LoadSummaryINTL[Month],1),0)

Anonymous 

There are small mistakes,  there is only 30 days in June. So change 5 to 6 in your formula:

IF(vw_LoadSummaryINTL[Month]= 6 , 30,

 

 

Or you may just use the simple version:

Transaction Date =

var day_= IF(vw_LoadSummaryINTL[Month] = 2,28,

IF(vw_LoadSummaryINTL[Month] in {4,6,9,11}, 30, 31))

RETURN DATE([Year],[Month],day_)

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.