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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago
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.