Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Share some data to work with (in a format that can be pasted in an MS Excel file) and show the expected result.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks Ashish, we are getting closer...

 

Maybe because I gave you fictional data and not described my desired outcome you've created a literal version... I wish to be able to summarise the 'price' calculated by whatever view I choose. So if I take your response and change to view by month instead of product, I get an error in the ASP_LY and therefore price too.

 

Sorry if I was not clear, I am trying to make this measure 'smart' and 'dynamic' so I can interogate data in whatever way I wish. Hence I though that using the SAMEPERIODLASTYEAR in the SUMX would somehow dynamically adjust to my desired view at the time...

 

Does that make more sense?

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    You are welcome.  You may download my revised PBI file from here.

    Hope this helps.