Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Model Name | MOQ | Order date 1 | MOQ 1 | Order date 2 | MOQ 2 |
A | 100 | 1/1/2021 | 100 | 1/1/2021 | 500 |
A | 200 | 1/2/2021 | 100 | 1/8/2021 | 400 |
B | 700 | 1/3/2021 | 100 | 9/9/2021 | 3000 |
A | 300 | 1/4/2021 | 300 | 6/9/2021 | 300 |
C | 1000 | 1/1/2021 | 100 | 1/6/2021 | 100 |
How to add the same model MOQ together and do comparsion with MOQ 1 and 2
A MOQ1: (100+200+300) VS (100 +100+300) 600 VS 500 NOT MEET MOQ
A MOQ2: (100+200+300) VS (500+400+300) 300 VS 1200 MEET MOQ
B MOQ1: (700) VS (100) NOT MEET MOQ
C MOQ1: (1000) VS (100) NOT MEET MOQ
I would like to show if NOT MEET MOQ / MEET MOQ
Can we create a column with that ? how to write "same model add together" formula?
Solved! Go to Solution.
@SelflearningBi , Based on what I got
it should be measures like
m1= sum(Table[MOQ])
m2 = sum(Table[MOQ 1])
if you need columns
c1= calculate(sum(Table[MOQ]), filter('Table',[Model Name'] = earlier(Table[Model Name]) ))
c2 = calculate(sum(Table[MOQ 1]), filter('Table',[Model Name'] = earlier(Table[Model Name]) ))
@SelflearningBi , Based on what I got
it should be measures like
m1= sum(Table[MOQ])
m2 = sum(Table[MOQ 1])
if you need columns
c1= calculate(sum(Table[MOQ]), filter('Table',[Model Name'] = earlier(Table[Model Name]) ))
c2 = calculate(sum(Table[MOQ 1]), filter('Table',[Model Name'] = earlier(Table[Model Name]) ))
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
80 | |
40 | |
31 | |
27 | |
27 |