Forum Discussion
Solved
Calenderauto function shows 1899 results after Datetime.localnow is set to time only
Dear Readers, After I finished my dashboard I wanted to add a 'Refresh date/time'. Used a blank query in the Query Editor with '= DateTime.LocalNow()' The moment I duplicate it and Transform it...
I solved the problem by not changing the Refresh Time type in the Power Query Editor. Instead I loaded the data in the Power BI Desktop and went to Data. Here I changed the Data type of the column Refresh Time to Time. Changing the datatype here didn't mess with the CALENDARAUTO(12) what fixed the problem. amitchandak so with your tip I managed to fix it.
I solved the problem by not changing the Refresh Time type in the Power Query Editor. Instead I loaded the data in the Power BI Desktop and went to Data. Here I changed the Data type of the column Refresh Time to Time. Changing the datatype here didn't mess with the CALENDARAUTO(12) what fixed the problem. amitchandak so with your tip I managed to fix it.