Solved: Dax query

korencheva · ‎07-03-2022

Hello!

Can you please tell me where the error is? How do I get this command to work? I have to express the unit per case

(Sheet1[unit per case]]) := DIVIDE ( Sheet1[Volume in unit cases]] ), ( Sheet1[Full Delivered margin]] )

Thank you in advance!

Jihwan_Kim · ‎07-03-2022

Hi,

If you are looking for creating a new column, please try the below or similar to the below.

It is for creating a new column.

unit per case CC =
DIVIDE ( Sheet1[Volume in unit cases], Sheet1[Full Delivered margin] )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Jihwan_Kim · ‎07-03-2022

Hi,

If you are looking for creating a new column, please try the below or similar to the below.

It is for creating a new column.

unit per case CC =
DIVIDE ( Sheet1[Volume in unit cases], Sheet1[Full Delivered margin] )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Dax query