Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Average YTD with summarized data

I am attempting to show average ytd (Jan shows Jan, Feb shows av(Jan,Feb), Mar shows av(Jan,Feb,Mar)...) in a line graph, but I cannot figure it out. I have east coast and west coast data. Each ins...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like the attached.

Please check the attached pbix file. All measures are in the attached pbix file.

I hope the below can provide some ideas on how to create solutions for your dataset.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Jihwan,

This solution is close but not quite right. I feel like there is an issue with the measure titled "quantity measure:" as I am not sure how that one is being filtered to return only East values, if at all. When I return the ratio measure, I get periodic east/total, but cannot yet year to date averages.