Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i have data like below with duplicate values in the avg column and from the date i need month year as x-axis for the line chart.
i need to show the running total of the avg in line chart removing that duplicates values.
Solved! Go to Solution.
Thanks Getting the average correctly . is this measure can be used for creating the running total .
Hey @Anonymous ,
OK, so you want the running total over the column average. That's different to the running average.
What should happen on Januar 17?
Is January 2017 = 255+1789+247 + 1789 + 45
Or is January 2017 = 45
That was my question in the post before.
Hey @Anonymous ,
here you go:
Average =
VAR vMinDate = FIRSTDATE(ALL('myTable'[Date]))
VAR vMaxDate = LASTDATE('myTable'[Date])
VAR vFilteredTable = FILTER(ALL('myTable'), 'myTable'[Date] >= vMinDate && 'myTable'[Date] <= vMaxDate)
VAR vSummarizeTable = SUMMARIZE(vFilteredTable,'myTable'[Date], 'myTable'[Avg])
RETURN
SUMX(vSummarizeTable, 'myTable'[Avg])
Hey @Anonymous ,
you can get the correct average by removing the duplicates for your calculation.
Try the following measure:
Average =
VAR vSummarizeTable = SUMMARIZE('myTable','myTable'[Date], 'myTable'[Avg])
RETURN
AVERAGEX(vSummarizeTable, 'myTable'[Avg])
Thanks Getting the average correctly . is this measure can be used for creating the running total .
Hey @Anonymous ,
you mean the running average?
Do you want to calculate the average from the beginning of the year to the day specified or from the beginning of all data up to the day specified?
For that you have to modify it a little, but I can do that if you tell me which of the two above you need.
Hi,
Share the link from where i can download your PBI file.
Hey @Anonymous ,
OK, so you want the running total over the column average. That's different to the running average.
What should happen on Januar 17?
Is January 2017 = 255+1789+247 + 1789 + 45
Or is January 2017 = 45
That was my question in the post before.
Hey @Anonymous ,
here you go:
Average =
VAR vMinDate = FIRSTDATE(ALL('myTable'[Date]))
VAR vMaxDate = LASTDATE('myTable'[Date])
VAR vFilteredTable = FILTER(ALL('myTable'), 'myTable'[Date] >= vMinDate && 'myTable'[Date] <= vMaxDate)
VAR vSummarizeTable = SUMMARIZE(vFilteredTable,'myTable'[Date], 'myTable'[Avg])
RETURN
SUMX(vSummarizeTable, 'myTable'[Avg])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
102 | |
79 | |
73 | |
65 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |