Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am new to Dax, have a formula but don't know how to minimize it-
Current Month Average =
IF (
'Table'[Tracking Parameters] = "PO Receipt to SO Creation",
AVERAGE(Sheet1[PO Receipt to SO Creation]
),
IF('Table'[Tracking Parameters] = "SO Creation to SO Release",
AVERAGE(Raw[SO Creation to SO Release]
),
IF('Table'[Tracking Parameters] = "SO Release to SO Planning",
AVERAGE('TAT Report'[SO Release to SO Planning]
),
IF('Table'[Tracking Parameters] = "Planning to Vehicle Reporting",
AVERAGE('TAT Report'[Planning to Vehicle Reporting]),
IF('Table'[Tracking Parameters] = "Vehicle Reporting to Vehicle GateIn",
AVERAGE('TAT Report'[Vehicle Reporting to Vehicle Gate In]),
IF( 'Table'[Tracking Parameters] = "Vehicle Gate In to Vehicle Gate Out",
AVERAGE('TAT Report'[Vehicle Gate In to Gate Out]),
IF( 'Table'[Tracking Parameters] = "Dispatch To Delivery",
AVERAGE('TAT Report'[TAT 9 Transit Time (Dispatch to Delivery)(Hours)]),
0)
)
)
)
)
)
Solved! Go to Solution.
Hi,
Please try something like below whether it suits your requirement.
Current Month Average =
SWITCH (
'Table'[Tracking Parameters],
"PO Receipt to SO Creation", AVERAGE ( Sheet1[PO Receipt to SO Creation] ),
"SO Creation to SO Release", AVERAGE ( Raw[SO Creation to SO Release] ),
"SO Release to SO Planning", AVERAGE ( 'TAT Report'[SO Release to SO Planning] ),
"Planning to Vehicle Reporting", AVERAGE ( 'TAT Report'[Planning to Vehicle Reporting] ),
"Vehicle Reporting to Vehicle GateIn", AVERAGE ( 'TAT Report'[Vehicle Reporting to Vehicle Gate In] ),
"Vehicle Gate In to Vehicle Gate Out", AVERAGE ( 'TAT Report'[Vehicle Gate In to Gate Out] ),
"Dispatch To Delivery", AVERAGE ( 'TAT Report'[TAT 9 Transit Time (Dispatch to Delivery)(Hours)] ),
0
)
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.
Hi,
Please try something like below whether it suits your requirement.
Current Month Average =
SWITCH (
'Table'[Tracking Parameters],
"PO Receipt to SO Creation", AVERAGE ( Sheet1[PO Receipt to SO Creation] ),
"SO Creation to SO Release", AVERAGE ( Raw[SO Creation to SO Release] ),
"SO Release to SO Planning", AVERAGE ( 'TAT Report'[SO Release to SO Planning] ),
"Planning to Vehicle Reporting", AVERAGE ( 'TAT Report'[Planning to Vehicle Reporting] ),
"Vehicle Reporting to Vehicle GateIn", AVERAGE ( 'TAT Report'[Vehicle Reporting to Vehicle Gate In] ),
"Vehicle Gate In to Vehicle Gate Out", AVERAGE ( 'TAT Report'[Vehicle Gate In to Gate Out] ),
"Dispatch To Delivery", AVERAGE ( 'TAT Report'[TAT 9 Transit Time (Dispatch to Delivery)(Hours)] ),
0
)
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |