Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Group BY

Expression.Error: We cannot convert the value true to type Text    
Need Help
  • jbwtp's avatar
    jbwtp
    4 years ago

    Hi Anonymous, 

    ronrsnfld asked a very valid question :). Do you want to do OR or AND or something else? Also you are referring to a DAX formula, but the Errors and screenshots seems to be from Power Query.

     

    This PQ code does OR on [Open], to make it ANDjust change List.Max to List.Min. Or do you need something else to happen on grouping (or do you need this in DAX)?

    Table.Group(Source, {"Account"}, {{"Count", each Logical.From(List.Max(List.Transform([Open], each Number.From(Logical.From(_))))), type logical}})

     

    Cheers,

    John

     

  • jbwtp's avatar
    jbwtp
    4 years ago

    Hi Anonymous,

     

    This is opening/closing brackets issue around this place: type logical}}), {{"Closed". At first sight, the formula should look like this:

     

    Table.Group(#"Removed Columns", {"Account Name"}, {{"Open",each Logical.From(List.Max(List.Transform([Open], each Number.From(Logical.From(_))))), type logical}, {"Closed", each Logical.From(List.Max(List.Transform([Closed], each Number.From(Logical.From(_))))), type logical}})

     

     

    I did not test it, but should work by the lok of it.

     

    Kind regards,

    John

Anonymous's avatar
Anonymous
Not applicable
4 years ago

jbwtp Thank  you  so much.  The  PQ code  which you   have  pasted works. 🙂

Thats what  I was looking for  🙂   ronrsnfld Appereciate  you from taking  this up.

I  have started  to learn about Power Query  , Power BI & DAX.  This  is  all very  new to  me, also  would appereciate  you if  you guys  could   maybe  tell me  about   good resources  for Power BI, DAX & Power Query.Currently  I am just learning in BITS  & pieces from Youtube.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    jbwtp   Sorry I just came across   syntax issue for this-

     

    Table.Group(#"Removed Columns", {"Account Name"}, {{"Open",each Logical.From(List.Max(List.Transform([Open], each Number.From(Logical.From(_))))), type logical}}), {{"Closed", each Logical.From(List.Max(List.Transform([Closed], each Number.From(Logical.From(_))))), type logical}})

     

    Please have a look and help me rectifying this.

    • jbwtp's avatar
      jbwtp
      Memorable Member
      4 years ago

      Hi Anonymous,

       

      This is opening/closing brackets issue around this place: type logical}}), {{"Closed". At first sight, the formula should look like this:

       

      Table.Group(#"Removed Columns", {"Account Name"}, {{"Open",each Logical.From(List.Max(List.Transform([Open], each Number.From(Logical.From(_))))), type logical}, {"Closed", each Logical.From(List.Max(List.Transform([Closed], each Number.From(Logical.From(_))))), type logical}})

       

       

      I did not test it, but should work by the lok of it.

       

      Kind regards,

      John