Forum Discussion

shakirkhanani's avatar
shakirkhanani
Helper I
8 years ago
Solved

How to convert SQL syntax to Dax

Is it possible to convert following command into Dax, in order to convert Georgian date into Hijri: With respect to SQL Server 2012: SQL Serverer 2012 introduces a new Format function that used t...
Need Help
  • shakirkhanani's avatar
    shakirkhanani
    8 years ago

    HI v-xjiin-msft,

     

    Thank you for taking part in my small request.  

     

    I will definitely share under IDEA.

     

    My work around was simillar as suggested by yourself and other participant.  Under excel, in one column I entered dates, convered them in Hijri and format them as Text, and connected this table to my Power BI Desktop, and relate them with the Date table. 




    This help me get the desired results.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi shakirkhanani,

 

Try  FORMAT(Table[Date],"DD/MM/YYYY")

 

Hope this works.

shakirkhanani's avatar
shakirkhanani
Helper I
8 years ago

Thanks for the suggestion.  Unfortunately it didnt work.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Could you try replace in Edit Query (screenshot attached), and see if it works? 

     

     

     

     

    • shakirkhanani's avatar
      shakirkhanani
      Helper I
      8 years ago

      It doesnt. But thanks for chipping in.  Basically I wanted to convert the Georgian date into Hijri (solar calendar).  I tried under Change Tyepe -> Locale as well:



      However, the column still shows Georgina date and not as above, please see below:

      • precedence's avatar
        precedence
        Frequent Visitor
        8 years ago

        I see, it doesn't appear that Power BI supports that from anything I can find.  You may have to treat it as text and convert/format it manually.

  • precedence's avatar
    precedence
    Frequent Visitor
    8 years ago

    Is the date column formatted as a date in the Modeling tab on the Ribbon?  You can also format Dates using Power BI's built in format on the ribbon there too.