Switch statement issues

[navneet0512]

ACTUAL WORKING DAYS PERFORMANCE = SWITCH (

True(),

--[Actual Working Days] = blank(), "null",

[Actual Working Day] < -19 , "Late 20+ days",

([Actual Working Day] <= -11 && [Actual Working Day] > -19 ), "Late 11-19 Days",

[Actual Working Day] <= -6, "Late 6-10 Days",

[Actual Working Day] <= -3, "Late 3-5 Days",

[Actual Working Day] <= -1 , "Late 1-2 Days",

[Actual Working Day] = 0, "OnTime",

([Actual Working Day] >= 1 && [Actual Working Day] <= 2), "Early 1-2 Days",

([Actual Working Day] >= 3 &&[Actual Working Day] <= 5), "Early 3-5 Days",

([Actual Working Day] >= 6 && [Actual Working Day] <= 10), "Early 6-10 Days",

([Actual Working Day] <= 11 && [Actual Working Day] <= 19), "Early 11-19 Days",

[Actual Working Day] > 19 , "Early 20+ Days", "Unknown"

)

[parry2k]

Thanks for adding more confusion. As in my previous reply I asked for pbix file, if you cannot provide one then I have no idea how to assist. I hope someone else will able to help. Good luck!

[parry2k]

@navneet0512 I could be wrong but I have a feeling that you are mixing up measures and columns (calculated columns). I would recommend sharing a pbix file with the sample data using one drive/google drive and removing any sensitive information before sharing.

[navneet0512]

As I am using calcualted measure only so I am surpried . 

[navneet0512]

Bucket is not allined with actual working days :-
Actual working day is calcualted column .
Actual working days :- X-Networkingdays here x is also a column from same table and networking day is calculated column .

ACTUAL WORKING DAYS PERFORMANCECommunity = SWITCH (

True(),

--[Actual Working Days] = blank(), "null",

[Actual Working Day] <= -20 , "Late 20+ days",

([Actual Working Day] < -10 && [Actual Working Day] > -20 ), "Late 11-19 Days",

([Actual Working Day] <= -6 && [Actual Working Day] > -11), "Late 6-10 Days",

([Actual Working Day] <= -3 && [Actual Working Day] > -6), "Late 3-5 Days",

[Actual Working Day] <= -1 , "Late 1-2 Days",

[Actual Working Day] = 0, "OnTime",

([Actual Working Day] >= 1 && [Actual Working Day] <= 2), "Early 1-2 Days",

([Actual Working Day] >= 3 && [Actual Working Day] <= 5), "Early 3-5 Days",

([Actual Working Day] >= 6 && [Actual Working Day] <= 10), "Early 6-10 Days",

([Actual Working Day] >= 11 && [Actual Working Day] <= 19), "Early 11-19 Days",

[Actual Working Day] >= 20 , "Early 20+ Days", "Unknown")

[parry2k]

@navneet0512 In Actual Working Days column what is the GLMLTT, column or a measure?

[navneet0512]

GLMLLT is column in table and working day num is calulated column .

[parry2k]

I asked two questions. Can you take a moment to answer both?

[navneet0512]

Both are calculated column :- 

[parry2k]

@navneet0512 answer this:

- Is this a measure or a column: Actual Working Days

- Are you adding this as  a calculated column or a measure: ACTUAL WORKING DAYS PERFORMANCE

[navneet0512]

Calcualted Column it is..

[Kishore_KVN]

Hello @navneet0512 ,

Please use below calculation it may work for you:

ACTUAL WORKING DAYS PERFORMANCE = SWITCH (

True(),

--[Actual Working Days] = blank(), "null",

[Actual Working Day] < -19 , "Late 20+ days",

([Actual Working Day] <= -11 && [Actual Working Day] > -19 ), "Late 11-19 Days",

([Actual Working Day] <= -6 && [Actual Working Day] > -11), "Late 6-10 Days",

([Actual Working Day] <= -3 && [Actual Working Day] > -6), "Late 3-5 Days",

[Actual Working Day] <= -1 , "Late 1-2 Days",

[Actual Working Day] = 0, "OnTime",

([Actual Working Day] >= 1 && [Actual Working Day] <= 2), "Early 1-2 Days",

([Actual Working Day] >= 3 &&[Actual Working Day] <= 5), "Early 3-5 Days",

([Actual Working Day] >= 6 && [Actual Working Day] <= 10), "Early 6-10 Days",

([Actual Working Day] <= 11 && [Actual Working Day] <= 19), "Early 11-19 Days",

[Actual Working Day] > 19 , "Early 20+ Days", "Unknown"

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[navneet0512]

What is the different in my statement and your? all are same 

[Kishore_KVN]

No for -6 and -3 defined outer limits as well

[navneet0512]

Still facing same issues

[Kishore_KVN]

Can you show what is the data type of that measure you have created which is Actual Working Day. Also please share its calculation if possbile. 

[navneet0512]

[navneet0512]

ACTUAL WORKING DAYS PERFORMANCE = SWITCH (

True(),

--[Actual Working Days] = blank(), "null",

[Actual Working Day] < -19 , "Late 20+ days",

([Actual Working Day] <= -11 && [Actual Working Day] > -19 ), "Late 11-19 Days",

[Actual Working Day] <= -6, "Late 6-10 Days",

[Actual Working Day] <= -3, "Late 3-5 Days",

[Actual Working Day] <= -1 , "Late 1-2 Days",

[Actual Working Day] = 0, "OnTime",

([Actual Working Day] >= 1 && [Actual Working Day] <= 2), "Early 1-2 Days",

([Actual Working Day] >= 3 &&[Actual Working Day] <= 5), "Early 3-5 Days",

([Actual Working Day] >= 6 && [Actual Working Day] <= 10), "Early 6-10 Days",

([Actual Working Day] <= 11 && [Actual Working Day] <= 19), "Early 11-19 Days",

[Actual Working Day] > 19 , "Early 20+ Days", "Unknown"

)