Forum Discussion
Row level measure syntax: (Current year data) minus (SAMEPERIODLASTYEAR data) * Quantity
Hi, I'm new to DAX... I am trying to create a measure that calculates (i.e. calculates row by row, then aggregates): ( (Current year sales / Current year quantity) - (Prior year sales / Prior...
Hi,
Share some data to work with (in a format that can be pasted in an MS Excel file) and show the expected result.
Hi,
Share some data to work with (in a format that can be pasted in an MS Excel file) and show the expected result.
Brilliant, that did the trick - thank you!
I will check of as accepted, and have another I will raise now in a separate thread
Mark
You are welcome. If my previous reply helped, please mark that reply as Answer.