CODEWITHSUNDEEP
reporting-servicespowerbidaxssrs-2008
Emily Oliver
Emily Oliver

Reputation: 3

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?

Upvotes: 0

Views: 83

Answers (2)

Ollie
Ollie

Reputation: 11

I think what you want is this:

IF(ISBLANK(DivisionOrderType), "", DivisionOrderType & " " & FORMAT(PrelimDOI, "yyyy-mm-dd"))

In this example, DivisionOrderType and PrelimDOI are assumed to be column names in the Power BI data model. If these columns have a different name in your data model, you'll need to replace them with the correct column names in the expression.

Upvotes: 0

Chandana Sai V
Chandana Sai V

Reputation: 54

can you try like this...

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

Upvotes: 1

Related Questions