Search code examples
reporting-servicespowerbidaxssrs-2008

SSRS expression to DAX powerbi convertion

IIF(IsNothing(Fields!DivisionOrderType.Value), "",Fields!DivisionOrderType.Value & " " & FormatDateTime(Fields!PrelimDOI.Value, DateFormat.ShortDate))

Need of dax formula in powerbi, is it possible? can anyone help?

Solution

  • can you try like this...

    If(Isblank(DivisionOrderType)," ",DivisonOrderType&" "&Format(PrelimDOI,"DD-MM-YYYY"))