Forum Discussion

chat_peters's avatar
chat_peters
Icon for Helper III rankHelper III
3 years ago

SSAS - How to use the format string function in the column properties to change the formatting

Hello,

 

I have a date_key column with data type whole number and formatted as Text as shown below.

 

 

I want to apply this same logic to the date_key column in another table for my measure to work. I don't remember how to use the custom formatting and what do I put in the format string section. Does this use power query or dax. 

 

Please please help!

3 Replies

  • foodd's avatar
    foodd
    Icon for Community Champion rankCommunity Champion

    Thank you for starting a conversation in the Power BI Desktop Forum.   Unfortunately, your 

    question relates to SSAS which belongs to another Support Forum.   The SSAS forum has

    migrated over to Microsoft Q&A SQL Server.

  • Thank you for pointing me in the right direction. I will move my question to that forum!

    • foodd's avatar
      foodd
      Icon for Community Champion rankCommunity Champion

      Glad to be of help.  

       

      Feel free to mark as a solution, and always open to Kudos.