Forum Discussion

MRN8840's avatar
MRN8840
Helper I
7 years ago

YTD average on line chart

Hi!   New member here :-)   I have a line chart showing to water usage (in m3) in a building for the last 8 days. The data comes from a Power BI Dataflow every morning with readings from the prev...
Need Help
MRN8840's avatar
MRN8840
Helper I
7 years ago

Hi Anonymous 

 

Sorry to have kept you waiting, I have been on holiday for the last three weeks :-)

 

Your first measure works, but the problem is it only sums up the number of days in the visualization. I need it to sum up all the numbers from january 1st.

 

 

As you can see the result of the first measure is only 109.22 = the measures for the last eight days. I need the sum from the whole year.

 

In my project I also have a date table including i coloumn with 'Day in year'. Does this make it easier? :-)

 

Thank you so much :-)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi MRN8840 ,

 

measure1 = calculate(sum(Aflæsning),Måler_ID in {"first_id","second_id","third_id"})

I'm not sure why above measure only show 8 days in your chart, because you  can see in the measure, there is no any limitation about the date, and if your chart is also no limitation about the date, I think maybe for the 3 id that you choose, there is only 8 days data for them, right?

if not, could you please show your dimension and expression of you chart?

Thanks.

Aiolos Zhao