Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Display average value from previous Year/Quarter/Month if current is empty

Good day everyone.

 

I'm new in Power Bi, so hope for your help 🙂

 

I have a line chart that displays a few average values by dates (X-axis - DateTime column, Y-axis - a few other columns with selected 'Average' option)

I use Categorical type, so the point is missing if there is no data in appropriate datetime interval:

 

 

 

I have to replace this logic to display data from previous Year/Quarter/Month (due to selected Hierarchy level) in case if current is empty to avoid these 'gaps'.

As I understand, I have to use Measure, but I've tried to use something like this: Measure = IF(ISBLANK(AVERAGE(Table[Value3])), 0, AVERAGE(Table[Value3]))

And i can't understand what should be instead of '0' to get previous calculation data (due to screen, in 2021 Qtr3 should be displayed '2' (Average value from 2021 Qtr2), so 2021 Qtr2, 2021 Qtr 3 and 2022 Qtr3 will be connected without gaps)

 

Could someone help me with this moment (or maybe there is exists another solution)?

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi v-kkf-msft ,

      My bad. Forgot about this)

      Here is some data: