Forum Discussion

Nick001's avatar
Nick001
Frequent Visitor
5 years ago
Solved

Date column in Excelpivot incorrect format

Hi, everyone, I have created an access from Excel to my Power BI data set (get data fram Dataset). The data also arrive in Excel and I can use the data model in a pivot. But now to my little challe...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  Nick001 ,

    Here are the steps you can follow：

    1. Enter the Power query interface and select the date column.

    2. Select the two columns, Right Click --Change Type - Using Locale.

    3. Select in Data Type: Date and Set the Locale (in your case you can use English - United States).

    If the result is not what you expected, can you share sample data and sample output in table format?

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  Nick001 ,

Here are the steps you can follow：

1. Enter the Power query interface and select the date column.

2. Select the two columns, Right Click --Change Type - Using Locale.

3. Select in Data Type: Date and Set the Locale (in your case you can use English - United States).

If the result is not what you expected, can you share sample data and sample output in table format?

 

Best Regards,

Liu Yang

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

  • Nick001's avatar
    Nick001
    Frequent Visitor
    4 years ago

    THX, that works great - sorry for the late answer