I don't know how to explain or title this. Let me give you my best shot.
I have a set of sales data, I want to create a measure that takes Qty * sale price per sku. Now the Issue is that the sale price changes every period.
How can I make a measure where the filter is dynamic according to the period inwhich the sale happened.
Something like this
Sales:=Qty times (sale price filtered by the sale's period price).
Does that make sense?
Thank you in advance!!
Go to Solution.
Right click [Product] column from Product Table and select Unpivot Other Columns in Query Editor, then add a calculated column to Raw Data.
'Product Table'[Product], 'Raw Data'[Product],
'Product Table'[Attribute], 'Raw Data'[Period]
SUMX ( 'Raw Data', 'Raw Data'[Qty] * 'Raw Data'[Price] )
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!