Forum Discussion

AparnaJ's avatar
AparnaJ
Helper I
7 years ago
Solved

Using If or Case along with Group by

Hi, We have a requirement, below is the data file.  Logic is as follows based on concept_name If Blast count <5; ANC ≥ 1;Platelet ≥ 100 then "good" group by synth_id,measurement_date. Please provi...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi AparnaJ 

    I find no text ("blast count", "ANC") in your example table.

    As searched, "ANC" seems to have a similar meaning as Neutro.

     

    If you recongnize Neutro as "ANC", you could take the following steps:

    1. In Power Query Editor, select column ‘concept_name’, and then click ‘Pivot Column’ and choose ‘value’ as ‘Value Column’.

     

    2. Does the statement -"If Blast count <5; ANC ≥ 1;Platelet ≥ 100 then "good" group" mean:

    Blast count <5 and ANC ≥ 1 and Platelet ≥ 100, these conditions are all Satisfied so that the group is a "good" one,

    If so, Create a column

    group column = IF('Table'[Neutro]>=1 && 'Table'[Platelets]>=100,"good","bad")

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi AparnaJ 

I find no text ("blast count", "ANC") in your example table.

As searched, "ANC" seems to have a similar meaning as Neutro.

 

If you recongnize Neutro as "ANC", you could take the following steps:

1. In Power Query Editor, select column ‘concept_name’, and then click ‘Pivot Column’ and choose ‘value’ as ‘Value Column’.

 

2. Does the statement -"If Blast count <5; ANC ≥ 1;Platelet ≥ 100 then "good" group" mean:

Blast count <5 and ANC ≥ 1 and Platelet ≥ 100, these conditions are all Satisfied so that the group is a "good" one,

If so, Create a column

group column = IF('Table'[Neutro]>=1 && 'Table'[Platelets]>=100,"good","bad")

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.