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.

shakirkhanani's avatar
shakirkhanani
Helper I
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.

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi shakirkhanani,

 

Thanks for shareing us your solution. Please kindly mark it as answer. It will benefit others with the relevant issue. :smileyhappy:

 

Thanks,
Xi Jin.