Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
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!!!
CHECK BELOW LINK FOR SOLUTION
https://community.powerbi.com/t5/Desktop/Cumulative-Count-by-Date/td-p/368918
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |