% Growth Year-over-Year of DISTINCTCOUNT of ID numbers

[timfooj]

Hello all,

I need help creating a Delta matrix populated with "% growth Year-over-year" with COLUMNS=Year Range and ROWS=Week of the year(Week1-week52). 

Below is the excel table i am trying to replicated. 

The populated numbers in columns 2-4 are a DISTINCTCOUNT(IdNumbers).  I am having trouble creating a measure that will populate the Delta %s in Columns 6-7. Thank you in advance.

[timfooj]

Thanks! Works for me. Would not have thought of this route. Much appreciated.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.