Forum Discussion
Average Line from another table
Read about the TREATAS() function.
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thanks lbendlin
I have looked at TREATAS() but I am not sure that this is giving me what I need.
| Date | Incident |
| 1 jan 2022 | A |
| 3 jan 2022 | B |
| 8 jan 2022 | A |
| 19 jan 2022 | A |
| 2 feb 2022 | C |
| 4 feb 2022 | A |
| 8 feb 2022 | B |
| 10 feb 2022 | C |
| 14 feb 2022 | A |
| Date | Quantity |
| 2 jan 2022 | 3% |
| 7 jan 2022 | 6% |
| 9 jan 2022 | 5% |
| 18 jan 2022 | 6% |
| 4 feb 2022 | 5% |
| 9 feb 2022 | 4% |
| 11 feb 2022 | 6% |
| 13 feb 2022 | 7% |
| 14 feb 2022 | 3% |
These two table are an example
And this is the kind of output but ideally I would like to show the line on the bar chart. The line is an average of per month, the bars are a count per month.
I can link the data but if I do that, either directly or via a calendar table (with days) neither works correctly.
Regards
Phillip
Seems to work fine for me?
see attached.