VAR / if error command?

Anonymous — Thu, 08 Sep 2022 06:36:12 GMT

Hello I m having a problem with advanced command. I want to assign cost price to component partlist "Prefix" column, but it needs to be searched on different filter name "FatherItemNo". downgraded subprocess.

The name of table is StockBillMat_DAT , "FatherItemNo" is product number, "ChildItemNo" is a id number of component. "Prefix" is name of component. Within "ChildItemNo" there is a reference for subprocess, that is available in "FatherItemNo".

"320" is constant for main level of production,

"500" constant for subprocess of 320.

"510" constant for subprocess of 500

Firstly filter needs to search for equal number within "FatherItemNo" for main process, example "3209121100" . IF component wasn't found in "prefix" column, go to subprocess. Apply search from "ChildNumberNo" that is available in "FatherItemNo". If name in "Prefix" not found, go to another subprocess.

I know its hard to understand, but i can show it live on teams if someone decide to

Re: VAR / if error command?

Anonymous — Fri, 09 Sep 2022 05:40:39 GMT

refresh

Re: VAR / if error command?

Anonymous — Fri, 09 Sep 2022 07:40:54 GMT

Hi Anonymous ,

Please take a look at switch function.

https://docs.microsoft.com/en-us/dax/switch-function-dax .

If you need detailed formula, please share some sample data and expected result.

Best Regards,

Jay

topic Re: VAR / if error command? in DAX Commands and Tips

VAR / if error command?

Re: VAR / if error command?

Re: VAR / if error command?