Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi!
Im pretty new to DAX and I need some help to calculate quantities. In most forum discussions I have seen all calculations are related to sales. My tables are not sales related but consist of case types and quantities of these cases. This means that I, for example, have a collum with various types of cases, and a collum with the number of the case. Each case is listed as number 1, but when I add a date columns I will see how many case types there are divided my month ( in visualization mode)
example: case type: audit , month: June, year: 2017 , number: 37
So I need a calculation where I can calculate the number of case types for a given period or see the difference between year/months.
Is there anyone who can help me with this, please?
My query name is Query2
and the collums are;
number
year
month number
month name
casetype
date
Thank you so much!!!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 17 | |
| 10 | |
| 7 | |
| 6 |