Forum Discussion

MarcRapenne's avatar
MarcRapenne
Frequent Visitor
6 years ago

Deaveraging prices

Hello!    I am pretty new to Dax and need help with the below problem:   I have a series of products with unique serial numbers that have been bought in a LOT at an average price of X / Unit ( in...
Need Help
MarcRapenne's avatar
MarcRapenne
Frequent Visitor
6 years ago

Hi V-lianl-msft ,

 

Thank you, this worked great!

Now I am wondering if I can keep adding filters within"EARLIER". Because unfortunately, after looking at all my historical data, some lots have different items within them which therefore have a different Buy Price (example pictured) 

This messes up the Adjusted Price since the calculation is at LOT level. I tried to add another Filter (Model) but something doesn't seem to be working. 

Thank you again for all your help!

Marc 

 

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi MarcRapenne ,

 

Yes, you can add appropriate filter conditions according to your own needs.

 

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

  • MarcRapenne's avatar
    MarcRapenne
    Frequent Visitor
    6 years ago

    Hi V-lianl-msft ,

     

    Thanks again. When I am trying to add the other filter to filter out the data via Model (after LOT) I get an error message. "Parameter is not the correct type". Please let me know if you have a solution for this.

     

    Formula Below: 

    AdjPrice =

    VAR COUNT_GOOD =CALCULATE( COUNT(ComprehensiveInventory[FunctionalGrade]),FILTER('ComprehensiveInventory',ComprehensiveInventory[FunctionalGrade]<>"NF"&&ComprehensiveInventory[LotNumber]=EARLIER(ComprehensiveInventory[LotNumber] && ComprehensiveInventory[Model]=EARLIER(ComprehensiveInventory[Model])))

     

    Thank you so much!

    Marc