5 Replies Latest reply on Feb 14, 2019 3:44 AM by Zhouyi Zhang

    MDX-Case or if else statement

    Nirmalraj Alagarsamy

      Hi team,

      I am Connecting to Cube Data source with tableau where we need to use one dimension in calculated field.For eg, Dimension Country has 3 values(AB,CD,EF).

      Measure named as unit.

       

      Case Country  :

      Country is 'AB' then 1.25*unit

      Country is 'CD' then 2.25*unit

      Country is 'DE' then  unit

       

      How to write above condition using MDX " Case or IF ELSE" statement ??

      Can anyone please let me know if you able to write mdx statement for this.An early reply is appreciated.

       

      Thanks in advance.

      Cell+91-9940207046