Forum Discussion
Average and Count in same Graph
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
I see how this is very useful, but my problem us the field could have an answer of a number in one row and another string, not together in the same field.
Yes
0
1
14:35
Nothing seen here
1
1
0
1/1/15
That is the problem. I am just trying to average the numbers for a specific entry.
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
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
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