Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Average and Count in same Graph

I am not able to include sample files so I hope I can explain this correctly.  I have a table with a column that the responses can range amoung several different answers.  What I am trying to do is s...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous,

     

    I think you can enter to query editor to add a column to check type and filter your formula to calculate average of rows which 'isnumber' is 'true'.

     

    Sample:

     

    Query:

    = Table.AddColumn(#"Changed Type", "Isnumber", each try Number.FromText([Test]) is number otherwise false)

     

    Result:

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

I think you can enter to query editor to add a column to check type and filter your formula to calculate average of rows which 'isnumber' is 'true'.

 

Sample:

 

Query:

= Table.AddColumn(#"Changed Type", "Isnumber", each try Number.FromText([Test]) is number otherwise false)

 

Result:

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I did try this and it was working for on of my dashbaords, but the one I am trying to use it on is a DirectQuery and when I went into the Advanced Query Editor, it told me I could not do this adding a new query.  Am I placing this in the wrong spot on the file.  Please advise.  Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    It seems like direct query not support to add custom columns. I haven't found other ways to work through this issue.

     

    Regards,

    Xiaoxin Sheng