Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I have created one measure named Quantity. Now I need to create one more measure using Toatl= Quantity * Table[cost].
Table looks like:
id Month ResvervedQty cost
1 Jan 5 100
1 Jan 7 200
1 jan 9 300
Suppose I have my Quantity = 7 , I need to use that cost which have same value as Quantity. In this case toatl= 7*200
Thanks in Advance
Hi @Milan6687 ,
How to get the formula for Measure? Please provide more details and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Milan6687 , You can not create a measure and column together in new column
Try a measure like
sumx (Table,[ResvervedQty ]*[Cost] )
But I need to compare Measure and cloumn value(ReservedQty) and based on this I need to select cost which will be then multiplied to my Measure.
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |