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 Team,
I quite newbie to Power BI DAX
Apology of this is silly question but I am not able to get it.
I have a table: has data for suppose 2010 to 2015 (refer table below). I want to get the output as a
Table where I will have 2 columns YEAR and DISTINCT COUNT OF QUANTITY YEAR WISE
note: I want a table. I am able to create measure for getting distinctcount of quantity.
below is a input table:
Year Month Day Quantity
2010 | 1 | 1 | 184 |
2010 | 2 | 22 | 130 |
2010 | 3 | 21 | 113 |
2010 | 4 | 13 | 122 |
2010 | 5 | 30 | 145 |
2010 | 6 | 12 | 157 |
2010 | 7 | 17 | 100 |
output table should be:
Year | Quantity |
2010 | 7 |
2011 | 9 |
2012 | 10 |
2013 | 20 |
2014 | 56 |
2015 | 78 |
Solved! Go to Solution.
@Anonymous , New table like
New table =
summarize(Table, Table[Year], "Qty", DISTINCTCOUNT(Table1[Quantity]))
@Anonymous , New table like
New table =
summarize(Table, Table[Year], "Qty", DISTINCTCOUNT(Table1[Quantity]))
Thanks alot its working.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |