Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |