copying "text" with if statement

Anonymous — Thu, 29 Oct 2020 14:54:07 GMT

Hey guys,

I'm trying to create a FTR (First time right).

The table creates "Fout" (False) as the text condition isn't correct.

To put it simple I'm trying to create that the text "Fout" will be copied to all the same 70X-XXX values.

For example in the picture:

- 704-434 -> "Loopactie opruimen" -> "Fout"

- 704-434 -> "Voorbereiden" -> "Fout" (currently returned as a null value)

What I need:

- A method to copy the "Fout" text if the conditions are correct

(as one of the 70X-XXX values contains a "Fout" text in the other column. The other 70X-XXX values with the same numbers should also have the "Fout"

With Kind regards,

SRMulti

Re: copying "text" with if statement

AlB — Fri, 30 Oct 2020 09:57:15 GMT

Hi Anonymous

You make it difficult to answer your question. You don't specify the names of the columns plus the sample data provided is a screen cap, which can not be copied and thrown into PBI to make a test.

This is a solution in DAX. I f you want it in Power Query please provide sample data in text-tabular format so that it can be copied.

Assuming the column with the 70X-XXX values is called Code and the column with the "Fout" and nulls is called Status, then create a new calculated column in your table (Table1):

New col = VAR commonStatus_ = CALCULATE ( MAX ( Table1[Status] ), ALLEXCEPT ( Table1, Table1[Code] ) ) RETURN IF ( ISBLANK ( Table1[Status] ), commonStatus_, Table1[Status] )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

topic Re: copying "text" with if statement in DAX Commands and Tips

copying "text" with if statement

Re: copying "text" with if statement