![]() ![]() Why is there more than one Islamic Calendar? for Saudi Arabia Umm-Al-Qura = “ B2dd/mm/yyyy”) For specific locales and calendars add IDs, e.g. Of course you can also go for mmmm to get the full month name in the Hijri date (changes the writing direction ⇒ "B2dd mmmm yyyy" to get e.g. Change the day, month, year order and the separators according to your needs.Ģ. ![]() You can also add further columns like a Hijri (YY)YY-MM column.ġ. ĭon’t just copy that column and change the format in Excel! Instead use for example = “B2dd/mm/yyyy”) īy this the Hijri date will be a text which Power Query will import as text and won’t automatically translate it back to a Gregorian date.Īdd also the Hijri year, the Hijri month, the Hijri month name and the Hijri day. The imported Hijri calendar table you can either merge with your standard calendar in Power Query or create a relation in the Power BI report.Ĭreate a column of the Gregorian dates you are interested in. And in Excel it is relatively easy to create Date columns with different date formatting. Problem and solution: First off you cannot change the date format in Power Query, but what you can do is to import a Hijri calendar table which you create in Excel. they might make special offers during the holy month of Ramadan and want to analyze the impact on the sales of this month. Why is it important: For companies in the Islamic world or in countries with an important Muslim community an analysis of their business activity according to the Hijri calendar makes a lot of sense. It is extremely relevant for all Muslims and also for companies dealing with the Islamic world and I learned a lot from this. Essam AbdulFattah asked me to help him convert Gregorian to Hijri in Power Query. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |