Date format Suadi Arabia to United State

[aboshabo]

I have a column contain data formatted as Saudi Arabia Date format (ex 10/05/1433), I need a column contain the equal date in United State's Date format (ex 08/05/2019).

Thanks for your support!

Best Regards

Mahmoud

[v-xuding-msft]

Hi @aboshabo ,

Would you mind marking helpful or prefer replies as answers? So that we are able to close the thread.

Welcome to share your own solution. More people will benefit from here.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft · Accepted solution]

Hi @aboshabo ,

It is not supported to change Gregorian date to Hijir date directly. You could change it in Excel, then import file to Power BI. And if the data is from SQL Server, I found a blog you can reference to change it. 

To make Power BI better, you can submit your request at Power BI Ideas and vote it up.

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @aboshabo 

You should format the date from the modeling menu.

Cheers!
A

[aboshabo]

Hi @Anonymous 

I found an Excel file shows the resutlt I am looking for.

https://www.dropbox.com/s/bp9rfx56x43s2zq/HijriDates.xlsx?dl=0

Maybe this question more clear " How to convert Hijri dates to Gregorian date?"

Thanks for your support!

Best Regards

Mahmoud

[Anonymous]

Hi @aboshabo 

I couldn't find the math for this kind of date.

I suggest you'll create a reference table of dates and then use a lookupvalue function.

Cheers!
A

[aboshabo]

Hi @Anonymous ,

thanks for your suggestion,
The solution you suggested is a format for date in different views, but my question was kind of converting the date to different location.

Attached an example.

https://www.dropbox.com/s/xgm9yloe6wy8dnp/Date%20Test.pbix?dl=0

Best Regards

Mahmoud