Warning alert in new column if any column value missing

[THENNA_41]

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 

[v-yangliu-msft · Accepted solution]

Hi  @THENNA_41 ,

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

[CNENFRNL]

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

[DimaMD]

Hi, @THENNA_41  Try it


Maybe there are more conditions?

[THENNA_41]

@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 

[DimaMD]

Hi @THENNA_41 Please provide a sample of the data

[THENNA_41]

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

Sample PBIX file 

Thank you..

[DimaMD]

@THENNA_41 What columns do you want to be in the condition?

[THENNA_41]

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

[DimaMD]

@THENNA_41  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")