Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DateDiff with multiple ISBLANK

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, I...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greg_Deckler ,

 

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

amitchandak's avatar
amitchandak
Super User
6 years ago

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