Regular values and cumulative total in matrix

[Sperling]

Hello,

I've got values for targets for a whole month, and with a days delay I get sales numbers.

I want to create a matrix showing the index of sales each day over the month compared to the daily targets. This is easily done, however I want the total in the bottom to be the cumulative index of these daily sales and targets up to the last reported day (yesterday).

At the moment the total in the bottom shows the index of the sales up to yesterday compared to the target for the whole month, which makes the total useless.

Is there a way to solve this issue?

[amitchandak]

@Sperling ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Sperling · Accepted solution]

Ended up finding a solution after a while of struggle. But thanks for the offer of help!

Index =

IFERROR(

   CALCULATE(

      [Sales] / [Target] * 100,

      FILTER(

         'Date',

         'Date'[Date] < TODAY()

      )

   ),

   BLANK()

)