1 Reply Latest reply on Sep 25, 2017 1:49 AM by lenaic.ridinger

    Date calculation in Microsoft Analysis Cube datasource on Tableau

    Rajashmita Kar

      Hi Guys,

       

      I am connecting to Microsoft Analysis Cube in Tableau. I have a date column in that. I am trying to create calculated date based on that but it does not work in cube

       

       

      IF MONTH([date])=12 THEN "1/1/"+STR(YEAR([date])+1)

      ELSE DATENAME('month',[date])+" "+STR(YEAR([date]))

      END

       

      Can anyone help me on this