Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Question on a What If Scenario

Hello all...   I created a What If parameter and named it "% Price Change." It created the below table and measure:   % Price Change = GENERATESERIES(-50, 50, 1) % Price Change Value = SELECT...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi and thank you. I think I figured it out. This code looks to be working:

     

    Revenue after % Price Change =
    SUMX('Item Sales','Item Sales'[Net Sales])
    + SUMX('Item Sales','Item Sales'[Qty] * 'Item Sales'[Price]
    * '% Price Change'[% Price Change Value]/100)

     

    Date            Item   Qty    Gross Sales  Discounts  Net Sales Unit   Price
    7/20/2019   1        9        $45.00         ($9.00)       $36.00      ea      $5.00
    9/21/2019   2        8        $40.00         ($8.00)       $32.00      ea      $5.00

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Can you please share some sample data and expected the result for test? It will help us clarify your scenario.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi and thank you. I think I figured it out. This code looks to be working:

 

Revenue after % Price Change =
SUMX('Item Sales','Item Sales'[Net Sales])
+ SUMX('Item Sales','Item Sales'[Qty] * 'Item Sales'[Price]
* '% Price Change'[% Price Change Value]/100)

 

Date            Item   Qty    Gross Sales  Discounts  Net Sales Unit   Price
7/20/2019   1        9        $45.00         ($9.00)       $36.00      ea      $5.00
9/21/2019   2        8        $40.00         ($8.00)       $32.00      ea      $5.00