Forum Discussion
Dynamic XYZ Analysis
Good Afternoon All, I recently been creating a data model using the dynamic abc classification on dax patterns, as well with the help of the powerbi community. I am now turning my attention towa...
I have realization of xyz analysis for retail. If you share your sample file, I will try to help you.
My formula of XYZ Measure:
XYZ :=
VAR CalcTable =
ADDCOLUMNS (
SUMMARIZE ( 'Retail Sales'; 'Calendar'[Month] );
"QuantityByMonth"; CALCULATE ( SUM ( 'Retail Sales'[Quantity] ) )
)
VAR Variation =
DIVIDE (
STDEVX.P ( CalcTable; [QuantityByMonth] );
AVERAGEX ( CalcTable; [QuantityByMonth] )
)
RETURN
IF (
ISBLANK ( Variation );
BLANK ();
IF ( Variation > 0,4; "Z"; IF ( Variation > 0,2; "Y"; "X" ) )
)
You can change grouping Month to you need. Hope this help you.Hello
What is mean BLANK in your formula?
