Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
carebear88
Frequent Visitor

Help - DAX calcuation for quantity measures year/month

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

 

0 REPLIES 0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.