Custom Column Error

[Anonymous]

Hi,

I need help on this Measure function. I tried below one got error. Any help on this?

if [Reference Date]>= [Last Date]
then
Floor(((year[Reference Date]*12)+Month[Reference Date])/3-((year[Last Date]*12)+Month[Last Date])/3))

[amitchandak · Accepted solution]

@Anonymous , Half DAX half power query

In power query

if [Reference Date]>= [Last Date]
then
Number.RoundDown(((Date.Year([Reference Date])*12)+Date.Month([Reference Date]))/3-((Date.Year([Last Date])*12)+Date.Year([Last Date]))/3)
else null

DAX like

if( [Reference Date]>= [Last Date]
,
Floor(((year([Reference Date])*12)+Month([Reference Date]))/3-((year([Last Date])*12)+Month([Last Date])/3)))

[Anonymous]

Small typo from your side. else all fine. You are awesome. 👍