Forum Discussion

tez's avatar
tez
Icon for Resolver I rankResolver I
6 years ago
Solved

Strange error with Date.DayOfWeek function

If I add a column with this function:   = Table.AddColumn(dbo_CMDB_PerformanceData, "WochentagStundeSort", each Date.DayOfWeek([Date], Day.Monday))   the column is displayed correctly in Power ...
Need Help
  • tez's avatar
    tez
    6 years ago

    Hi v-lid-msft ,

    good news: My colleague changed the type from datetime to datetime2 in the MSSQL view. After this both operations worked as expected!

    Regards,

    Thomas

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi tez ,

 

Can you provide this pbix ? Please mask some sensetive data.

tez's avatar
tez
Icon for Resolver I rankResolver I
6 years ago

camargos88 

thank you for your reply; I´m afraid you cannot use the file, because the error occurs when refreshing from the MSSQL Server, it does not occur with local data (I tried with a local table and an Excel datasource).

Regards,

Thomas.