Forum Discussion

hnowotny17's avatar
hnowotny17
Icon for Helper I rankHelper I
5 years ago
Solved

Sold Value counted from two Pricelist

Hello,   I would like to kindly ask anyone for the help.   I have a table with products, sold quantity and pricelist (price/product) and I would like to count "Sold Value" (Sold quantity*Price). ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    hnowotny17 , Try a new column like

     

    Switch( True(),
    [Date] >= date(2020,01,01) && [Date] <= date(2020,04,30) , [Pricelist S1] * [sold quantity],
    [Date] >= date(2020,05,01) && [Date] <= date(2021,01,31) , [Pricelist S2] * [sold quantity],
    blank()
    )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi hnowotny17  ,

Here are the steps you can follow：

1. Create measure.

Sold Value =
IF(MAX('Sell out Mallzart'[Date])>=DATE(2020,1,1)&&MAX('Sell out Mallzart'[Date])<=DATE(2020,4,1),

MAX('Sell out Mallzart'[Sold Quantity])*CALCULATE(SUM('Pricelist S1'[Price]),FILTER('Pricelist S1','Pricelist S1'[Ref.no]=MAX('Sell out Mallzart'[Ref.no]))),

MAX('Sell out Mallzart'[Sold Quantity])*CALCULATE(SUM('Pricelist S2'[Price]),FILTER('Pricelist S2','Pricelist S2'[Ref.no]=MAX('Sell out Mallzart'[Ref.no]))))

2. Result.

 

You can downloaded PBIX file from here.

 

Best Regards,

Liu Yang

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

  • hnowotny17's avatar
    hnowotny17
    Icon for Helper I rankHelper I
    5 years ago

    Dear Anonymous 

     

    Many thanks for your time! I follow your steps and it worked as well!

     

    Kind regards and thank you again,

    JN