Forum Discussion
Dax Variance and percentage computation code.
What is the code for these. I want to have.
1. Variance/ending balance. between Total delivered vs Total Sales 2. Percentage %
Thank you so much.🙏🏻
Hi JanCen ,
Please try below steps:
1. below is my test table
Table:
2. create measure with below dax formula
Variance = VAR cur_del = SELECTEDVALUE ( 'Table'[Total Delivered] ) VAR cur_sale = SELECTEDVALUE ( 'Table'[Total Sales] ) RETURN cur_del - cur_sale% Percent = VAR _sal = SELECTEDVALUE ( 'Table'[Total Sales] ) VAR _del = SELECTEDVALUE ( 'Table'[Total Delivered] ) RETURN FORMAT ( DIVIDE ( _sal, _del ), "Percent" )3. add a table visual with fields and measure
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi JanCen ,
Please try below steps:
1. below is my test table
Table:
2. create measure with below dax formula
Variance = VAR cur_del = SELECTEDVALUE ( 'Table'[Total Delivered] ) VAR cur_sale = SELECTEDVALUE ( 'Table'[Total Sales] ) RETURN cur_del - cur_sale% Percent = VAR _sal = SELECTEDVALUE ( 'Table'[Total Sales] ) VAR _del = SELECTEDVALUE ( 'Table'[Total Delivered] ) RETURN FORMAT ( DIVIDE ( _sal, _del ), "Percent" )3. add a table visual with fields and measure
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.