The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 to achieve the same result.
SELECT FORMAT ( GETDATE(), 'dd/MM/yyyy', 'ar-SA' )
Output
16/08/1435
Thanks in advance.
Regards,
M Shakir
Solved! Go to Solution.
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.
Hi @shakirkhanani,
As I know, currently we are using Georgian date format in Power BI Desktop no matter which region you are in. And it is unable to convert Georgian date into Hijri date within DAX. For the Hijri date format in Power BI, I would suggest you to submit an Idea here for a feature request.
Then in your scenario, if you still want to convert the date I would suggest you to do the work at SQL Server side and import the data into Power BI. But please be noticed that after converting, it is a text type value and is no longer a date type value.
Thanks,
Xi Jin.
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.
Hi @shakirkhanani,
Thanks for shareing us your solution. Please kindly mark it as answer. It will benefit others with the relevant issue.
Thanks,
Xi Jin.
I'm guessing the column isn't set to Data Type: Date
Thanks for the suggestion. Unfortunately it didnt work.
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.
Could you try replace in Edit Query (screenshot attached), and see if it works?
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:
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.
Yes... it appears so. very unfortunate.. But big thumbs to all, who shared their suggestions. Thank you guys.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
138 | |
106 | |
105 | |
73 | |
60 |
User | Count |
---|---|
266 | |
127 | |
119 | |
100 | |
88 |