Need help to convert tableau expression to DAX

[sreddy47652]

Hi I need to convert below tableau expression to Dax. (ZN(SUM([QTY Order-REQ-Fcst Selected Cycle])) - LOOKUP(ZN(SUM([QTY Order-REQ-Fcst Selected Cycle])), -1)) / ABS(LOOKUP(ZN(SUM([QTY Order-REQ-Fcst Selected Cycle])), -1))

[Anonymous]

Hi @sreddy47652 ,

Is there any progress on this issue?

If you find any answer is helpful to you, please remember to accept it.

It will help others who meet the similar question in this forum.

Thank you for your understanding.

[Anonymous]

Hi @sreddy47652 , dharmendars007, thank you for your prompt reply!

Based on your expression, try the measure as following:

VAR CurrentValue = COALESCE(SUM([QTY Order-REQ-Fcst Selected Cycle]), 0)
VAR PreviousValue = CALCULATE(
   COALESCE(SUM([QTY Order-REQ-Fcst Selected Cycle]), 0),
   PREVIOUSMONTH('Date'[Date]) 
)
RETURN
IF(
   PreviousValue <> 0,  
   (CurrentValue - PreviousValue) / ABS(PreviousValue),
   BLANK() 
)

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dharmendars007]

Hello @sreddy47652 

We need more context on the above formula like what exactly is the result expected , by the way formula look it looks like percent change comapred to last month, so you can try the below formula if this doesnt work, please give us more information..

Percentage Change =
VAR CurrentValue = SUM('YourTable'[QTY Order-REQ-Fcst Selected Cycle])
VAR PreviousValue =
CALCULATE(
SUM('YourTable'[QTY Order-REQ-Fcst Selected Cycle]),
DATEADD('YourDateTable'[Date], -1, MONTH) // Change MONTH to DAY, YEAR, etc., depending on your requirement
)
RETURN
DIVIDE(
(CurrentValue - PreviousValue),
ABS(PreviousValue),
0
)

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[sreddy47652]

It's throwing an error like  " A table expression containing more than one column specified in the call to function "DATEADD" is not supported.