![]() Here is an example with slicers implemented by Essam AbdulFattah: Copy it out from the space where you can adapt custom formats.Īpart from the use for business intelligence you can use the created calendar also for date conversion.At the beginning of the code you will see the ID.On the same cell reopen Format Cells (CTRL +1).Somewhere on a separate cell open Format Cells (CTRL +1).How to get the definition of the locales and calendar you are interested in? " B2" gives you the Saudia Arabia Hijri calendar. pre-calculated) and that they are handled differently in different countries. What was a surprise to me, were the many astrological and theological aspects and even controversies (actual moon sighting vs. Visibility of the new moon depends on various factors such as the weather. The beginning of each month is marked by the observance of a new moon seen for the first time. The Islamic calendar depends on the movement of the moon. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |