Forum Discussion

Marco_RC's avatar
Marco_RC
Copper Contributor
Nov 02, 2023

Language of month's name extracted from a date in a dynamic table from Power Pivot Data Model

Hi,   I have a problem with an Excel file that has been created in Windows 10 Pro with en-US regional format. The problem is that when I open it on a computer with Windows 10 Pro with es-MX regiona...
BI & Data Analysis
excel
Formulas and Functions
office 365
power bi
Marco_RC's avatar
Marco_RC
Copper Contributor
Nov 17, 2023

Hi Lorenzo ,

 

Thank you very much for the answer.

 

We used a similar approach through Power Query to resolve the problem. However, I'm sharing with you the sample workbook and I would like to know the details of your proposed solution, please.

Also we saw the format parameter on the MONTH dax function, and it is quite absurd that it is not supported in Excel, it would help a lot.

 

My concern is that, on a Pivot Table, when the user add a date type field, Excel automatically generate the conversion of the month and it will show the wrong value, so it is really misleading.

Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 05, 2023

Hi Marco_RC 

 

I thought you would provide (any kind of) feedback on what you asked to be shared

Maybe you're too busy these days...

  • Marco_RC's avatar
    Marco_RC
    Copper Contributor
    Dec 06, 2023

    Hi Lorenzo ,

     

    I'm so sorry I couldn't follow up yet, but it's on my to-do list. I'll let you know as soon as possible.

     

    Thanks,

    Marco

     

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Dec 07, 2023

      Hi Marco_RC 

       

      No worries at all & no rush 🙂

      In the meantime I checked with a friend of mine who has everything (OS, Regional Settings and Excel) in FR. When building a new Pivot Table from the Data Model, months are in FR no problem

      • Marco_RC's avatar
        Marco_RC
        Copper Contributor
        Dec 07, 2023

        Hi Lorenzo ,

         

        Thanks for following up, It is a very good finding! But He are using using the same workbook that I shared? And using the automatic field "Date (Month)" generated selecting the field Date on the Pivot Table fields list?

        It would change the scenario of the investigation..

        Thanks

         

Resources