Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to show true or false between row

Hi all,   Here is my data   Prod Order Date Completed Balance 100002720443 10/7/2023 262.5   100002720443 11/7/2023   32 100002620776 12/7/2023 31.5 11.1   My expecta...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi Anonymous ,

    According to your description, here's my solution.

    Add a custom column:

    if List.Count(List.Distinct(Table.SelectRows(#"Changed Type",(x)=>x[Prod Order]=[Prod Order])[Date]))>1 then "warning" else null

    Get the correct result:

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Vijay_A_Verma ,

 

Done as per your code but it show error

 

#"Grouped Rows" = Table.Combine(Table.Group(#"Changed Type", {"OrderNumber_AUFNR"}, {{"All", each Table.AddColumn(_, "Indicator", (x)=> try if _[DocumentDate_BLDAT]{0} <> _[DocumentDate_BLDAT]{1} then "Warning" else null otherwise null, type text)}})[All])

 

Regards,

Nuha

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
3 years ago

Did you change #"Changed Type" to your previous step in your PQ editor?

If your previous step was also #"Changed Type", then error is due to some other factor. Could you please post that error?