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!!!
