Forum Discussion
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...
Anonymous, I doubt your the usage of is blank in place of isnull, From March release power bi supported coalesce , please use that
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.
- 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.
Anonymous, I doubt your the usage of is blank in place of isnull, From March release power bi supported coalesce , please use that