topic Re: % Growth Year-over-Year of DISTINCTCOUNT of ID numbers in DAX Commands and Tips

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

timfooj — Fri, 04 Aug 2023 23:20:26 GMT

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.

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

Jihwan_Kim — Sat, 05 Aug 2023 06:20:20 GMT

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.

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

timfooj — Mon, 07 Aug 2023 20:36:52 GMT

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