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
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