Forum Discussion
Helper IIIHow to add same model name together
| 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?
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]) ))
1 Reply
- amitchandak
Super User
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]) ))