Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I am looking to do an if statement within a much larger if statement in Power BI.
This is what the formula would be based on.
It seems I have even better decision
Goal =
var denominator = IF(MOD(MONTH('Monthly Goals'[Booked by Goals]), 3) = 0, 30, 24)
var multiplier = IF(MONTH('Monthly Goals'[Booked by Goals]) < 7, 0.048, 0.057)
var D1BookedbyHoursGoal = ('Monthly Goals'[Booked by Goals] / denominator ) * multiplier
RETURN
IF([Attendance Measure] <= 4, D1BookedbyHoursGoal / 2, D1BookedbyHoursGoal )
Hi @arobinson
try var + switch()
Goal =
var D1BookedbyHoursGoal = SWITCH('Monthly Goals'[Month]
"January",
('Monthly Goals'[Booked by Goals] / 24) * .048,
"February",
('Monthly Goals'[Booked by Goals] / 24) * .048,
"March",
('Monthly Goals'[Booked by Goals] / 30) * .048,
"April",
('Monthly Goals'[Booked by Goals] / 24) * .048,
"May",
('Monthly Goals'[Booked by Goals] / 24) * .048,
"June",
('Monthly Goals'[Booked by Goals] / 30) * .048,
"July",
('Monthly Goals'[Booked by Goals] / 24) * .057,
"August",
('Monthly Goals'[Booked by Goals] / 24) * .057,
"September",
('Monthly Goals'[Booked by Goals] / 30) * .057,
"October",
('Monthly Goals'[Booked by Goals] / 24) * .057,
"November",
('Monthly Goals'[Booked by Goals] / 24) * .057,
"December",
('Monthly Goals'[Booked by Goals] / 30) * .057,
0)
RETURN
IF([Attendance Measure] <= 4, D1BookedbyHoursGoal / 2, D1BookedbyHoursGoal )
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!