topic calculating cummolative QTY (of countdistinct) orders for every year in DAX Commands and Tips

calculating cummolative QTY (of countdistinct) orders for every year

Anonymous — Wed, 22 Jan 2020 11:42:00 GMT

I have a data set that has Purchse orders numbers, i wish to countdistinct, cummaltaive QTY for every year by date.

so i will be able to produce line chart for every year, wehn the X- axis is months( jabuary, February,March....,December)

the lines shuould display cummaltive QTy by month to month for each year.

i have a dim_date table to use.

thanks!!!

Anonymous — Wed, 22 Jan 2020 11:47:08 GMT

CHECK BELOW LINK FOR SOLUTION

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

Anonymous — Wed, 22 Jan 2020 11:56:26 GMT

Hi,

it close to what i want, but i wish to count every year separatly.

i want to calculate for 2017 from 01/01/2017 - 31/12/2017

and afterward to calculate 2018 for the same period and that it will start the count from 0 and not continue the count of 2017.

thanks