topic Re: DateDiff with multiple ISBLANK in DAX Commands and Tips

DateDiff with multiple ISBLANK

Anonymous — Thu, 09 Apr 2020 13:19:42 GMT

Hi,

Could somebody please help me to convert my SQL to DAX below?

Sum(case when DateDiff(month, @ReportPeriodStartDate, TDate) < 0 AND

DateDiff(month, @ReportPeriodStartDate, Isnull(WDate, IsNull(CDate, @ReportDate))) > 0 then 1 else 0 end)

I have

DIM =

VAR ReportPeriodStartDate = DATEADD(vwtest[DateUpdated],-1,MONTH)

RETURN

IF(DATEDIFF(ReportPeriodStartDate, vwtest[TDate],MONTH) < 0 &&

DATEDIFF(ReportPeriodStartDate,ISBLANK(vwtest[WDate]),ISBLANK(vwtest[DateU],MONTH) > 0,1,0)

Its not displaying correctly. Its the isnulls that I'm struggling to convert I think

Any help would be greatly appreciated.

Thanks

Liam

Re: DateDiff with multiple ISBLANK

Greg_Deckler — Thu, 09 Apr 2020 13:22:57 GMT

Please don't just post SQL and ask "how do I do this in DAX?" Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Sample data, expected result.

Re: DateDiff with multiple ISBLANK

Anonymous — Thu, 09 Apr 2020 13:24:31 GMT

Hi Greg_Deckler ,

It was DAX also. The question was mainly around null values

Re: DateDiff with multiple ISBLANK

Greg_Deckler — Thu, 09 Apr 2020 13:28:15 GMT

Sometimes, depending on the data, which is why it is extremely helpful to see it, you need to do something like <> "" or = "null" or something along those lines.

Re: DateDiff with multiple ISBLANK

amitchandak — Fri, 10 Apr 2020 09:06:00 GMT

Anonymous, I doubt your the usage of is blank in place of isnull, From March release power bi supported coalesce , please use that