Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How does my calculation time of a measure depend on nested 'If' statement?
I have expressions which have atleast 4 nested 'If' statements. I want to know how does calculation time depend on nested 'If'?
May be this?
If(FieldName = 'A', Sum(Sales),
If(FieldName = 'A1', Sum(Sales1),
If(FieldName = 'A2', Sum(Sales2),
If(FieldName = 'A3', Sum(Sales3)
)
)
)
)