Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Community,
I have the below formula that is returning the above error - please can you help me get rid of the issue?
I'm trying to achieve a column that gives me a date & time field.
Formats:
Channel = Text
Parent Account = Text
Submitted = Date
SLA = Date&Time
CalcSLA = if('Master Table'[Channel]="IE Own Network",if(OR('Master Table'[Parent Account]="CUSTOMER A",'Master Table'[Parent Account]="CUSTOMER B"),format('Master Table'[Submitted],"General Number")+0.729167,if('Master Table'[Parent Account]="CUSTOMER C",format('Master Table'[Submitted],"General Number")+0.729167,format('Master Table'[Submitted],"General Number")+0.5)),if('Master Table'[Channel]="UK Own Network - NIGHT",format('Master Table'[Submitted],"General Number")+format('Master Table'[SLA Temp],"General Number"),format('Master Table'[SLA],"General Number"))) |
Solved! Go to Solution.
Hi @DrewCarousel ,
You could refer to the following DAX:
CalcSLA =
IF (
'Master Table'[Channel] = "IE Own Network",
IF (
OR (
'Master Table'[Parent Account] = "CUSTOMER A",
'Master Table'[Parent Account] = "CUSTOMER B"
),
VALUE ( FORMAT ( 'Master Table'[Submitted], "General Number" ) ) + 0.729167,
IF (
'Master Table'[Parent Account] = "CUSTOMER C",
VALUE ( FORMAT ( 'Master Table'[Submitted], "General Number" ) ) + 0.729167,
VALUE ( FORMAT ( 'Master Table'[Submitted], "General Number" ) ) + 0.5
)
),
IF (
'Master Table'[Channel] = "UK Own Network - NIGHT",
VALUE (
FORMAT ( 'Master Table'[Submitted], "General Number" )
+ FORMAT ( 'Master Table'[SLA Temp], "General Number" )
),
VALUE ( FORMAT ( 'Master Table'[SLA Temp], "General Number" ) )
)
)
Hi @DrewCarousel ,
You could refer to the following DAX:
CalcSLA =
IF (
'Master Table'[Channel] = "IE Own Network",
IF (
OR (
'Master Table'[Parent Account] = "CUSTOMER A",
'Master Table'[Parent Account] = "CUSTOMER B"
),
VALUE ( FORMAT ( 'Master Table'[Submitted], "General Number" ) ) + 0.729167,
IF (
'Master Table'[Parent Account] = "CUSTOMER C",
VALUE ( FORMAT ( 'Master Table'[Submitted], "General Number" ) ) + 0.729167,
VALUE ( FORMAT ( 'Master Table'[Submitted], "General Number" ) ) + 0.5
)
),
IF (
'Master Table'[Channel] = "UK Own Network - NIGHT",
VALUE (
FORMAT ( 'Master Table'[Submitted], "General Number" )
+ FORMAT ( 'Master Table'[SLA Temp], "General Number" )
),
VALUE ( FORMAT ( 'Master Table'[SLA Temp], "General Number" ) )
)
)
@DrewCarousel , Make sure all of them return text add & "" to make sure in all if and else
Hi Amit,
Thank you for this.
Please could you edit my original formula or give more guidance on where to place the &"".
Also to confirm, this will still add the decimal numbers to the original dates? To reiterate, I'm looking to get a date and time output.
Best regards,
Drew
@DrewCarousel : considering breaking the formula into multiple measures (a,b,c) so you can know exactly where the error is occurring. Then have your last output measure equal measure A + measure B + Measure C.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |