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
PhillipSeems to work fine for me?
see attached.
