topic SELECTEDVALUE in calculated column in DAX Commands and Tips

SELECTEDVALUE in calculated column

Anonymous — Thu, 01 Aug 2024 12:49:45 GMT

Hi,

I am looking to do something in a table, but I need to use a selectedvalue function to achieve the best results. Basically I have a quantity value, and am looking to apply a percent change to those values, whether it be an increase or decrease. Is there a way to get around the fact that I cannot do a selectedvalue in a column.

I have attached some images of wqhat I am working with.

In the end I am trying to apply a percent change to the quantity, before then taking that new quantity value and multiplying it by an entered number based on month and "Cut" of meat.

Here is a picture of the price table too.

Thanks!

Re: SELECTEDVALUE in calculated column

bhanu_gautam — Thu, 01 Aug 2024 12:54:43 GMT

Anonymous , Try using what if parameteres

Re: SELECTEDVALUE in calculated column

Anonymous — Thu, 01 Aug 2024 13:02:08 GMT

How do those work?

Re: SELECTEDVALUE in calculated column

bhanu_gautam — Fri, 02 Aug 2024 05:06:42 GMT

https://www.youtube.com/watch?v=jyKAxKSHBTk- Check this