1 Reply Latest reply on Jun 12, 2018 9:51 AM by patrick.byrne.0

    MSAS Data Source - Convert week number to mmm dd format

    Karan Garg

      I have been doing research for a while now but cannot figure out the steps to convert following time information into a date format. Essentially, I am not able to create a calculated member for this need. Need some help with the MDX expression

       

      Time is a dimension and it is in the following format in the source. 

       

      From

      Year      Month     Week

      2018     1               1

      2018     1               2

       

      To

      Jan Wk 1 ; Jan Wk 2

       

      I can try other option as well but need some help on the steps

       

      1 Create calculated member using [Year]+[Month]+[Week] something like this 201811, 201812 etc. Need help with the MDX expression since time is stored in dimension

      2 Join an excel mapping with MSAS cube. Tableau didnt gave me option to create a join when connected to MSAS cube.

       

      Any other recommendations to solve this problem are welcome !!

       

      PS: New to Tableau ; My first post in the community. Looking forward to hear from the experts...

       

      KG