topic Re: Warning alert in new column if any column value missing in DAX Commands and Tips

Warning alert in new column if any column value missing

Anonymous — Fri, 17 Jun 2022 06:44:24 GMT

I am using single table for mulitple Graph .Check is all items are present in th table. This means that if any item is missing vs reference table, tool should show a “Warning” in new column in

Summay Table

Item BOM Height Weight Volume

FW001 Pack 450 234

FW002 Pack 450 344 234

FW003 Pack 344 234

For Example :

Item BOM Height Weight Volume alert

FW001 Pack 450 234 Warning

FW002 Pack 450 344 234 Avaialbe

FW003 Pack 344 234 Warning

Any Idea .. looking for support . Thanks in advance

Re: Warning alert in new column if any column value missing

DimaMD — Fri, 17 Jun 2022 08:23:58 GMT

Hi, Anonymous Try it

Maybe there are more conditions?

Re: Warning alert in new column if any column value missing

CNENFRNL — Fri, 17 Jun 2022 13:00:26 GMT

Always resort to PQ when it comes to row-oriented processing.

let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45Wcgs3MDBU0lEKSEzOBlImpgZAEoiMjE2UYnUg8kbo8sYmJmhKjBFKUOVjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Item = _t, BOM = _t, Height = _t, Weight = _t, Volume = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Item", type text}, {"BOM", type text}, {"Height", Int64.Type}, {"Weight", Int64.Type}, {"Volume", Int64.Type}}), Flagged = Table.AddColumn(#"Changed Type", "Flag", each if List.Contains(Record.ToList(_), null) then "Available" else "Warning") in Flagged

Re: Warning alert in new column if any column value missing

Anonymous — Mon, 20 Jun 2022 04:49:26 GMT

DimaMD How to add multiple value for above Measure . i am trying to add two more column value above Dax . but i am getting error

Re: Warning alert in new column if any column value missing

DimaMD — Mon, 20 Jun 2022 05:57:38 GMT

Hi Anonymous Please provide a sample of the data

Re: Warning alert in new column if any column value missing

Anonymous — Mon, 20 Jun 2022 06:35:14 GMT

DimaMD please find the below Sample of Data PBIX d file .

Sample PBIX file

Thank you..

Re: Warning alert in new column if any column value missing

DimaMD — Mon, 20 Jun 2022 06:53:31 GMT

Anonymous What columns do you want to be in the condition?

Re: Warning alert in new column if any column value missing

Anonymous — Mon, 20 Jun 2022 07:19:46 GMT

DimaMD for all the column . if any column value missing its should warning and if all column value available its showing available alert

Re: Warning alert in new column if any column value missing

DimaMD — Mon, 20 Jun 2022 09:11:16 GMT

Anonymous Try it, if you missed the column try to add yourself.

alert = IF( AND(OR( [2D - Dimension 1 - Length [mm]] (Technical Drawing Details)] && [2D - Dimension 2 - Width [mm]] (Technical Drawing Details)] <> BLANK(), [Area [cm2]] (Technical Drawing Details)] && [BOM Number] <> BLANK()), [Cut-Off Length] && [Grammage [g/m2]] (from base mat./ TS)] && [Height (mm) (Shipping Case Details)] && [Weight [g]]] <> BLANK()), "Available","Warning")

Re: Warning alert in new column if any column value missing

Anonymous — Wed, 22 Jun 2022 01:56:43 GMT

Hi Anonymous ,

Here are the steps you can follow：

1. Go to Power query – Conditional Column.

2. Select Add Clause - add each column to it.

Operator – equals

Value -- null

Output -- Warning

Else -- Avaialbe

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly