Share via

About power Query

Anonymous
2024-08-10T06:26:29+00:00

Split from this thread.

thanks a lot , it works like magic .

I have another question that is not related to the Previous one maybe you can help me with this one too and if you do i really appreciate it .

How can I write this formula in power Query ?

Microsoft 365 and Office | Excel | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-08-10T07:59:07+00:00

    It sounds like you are still trying to create a pivot table with Persian dates and month names on an English system!?

    As a reminder, I'm still waiting for you data and a sign that you uploaded them:
    https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-create-a-persian-calendar-and-pivot-table/540ffc94-4f87-4b59-beed-66fde3ee069c

    The short answer to your questions is: There is no direct translation, but most date functions in M support a "culture" argument which is the language tag => "fa-IR": https://learn.microsoft.com/en-us/powerquery-m/date-monthname

    But the dates of a Persian calendar are not synchronous with the Gregorian calendar:

    Image

    I am not an expert on the Persian calendar, I know many calendars and each has its own peculiarities.

    If I say something wrong about the Persian calendar, please correct me.

    BTW, AFAIK there are also other month names in the region of Indo-Iranian, but it's not so easy to get them:
    Image

    Any further questions?

    Andreas.

    Was this answer helpful?

    0 comments