Forum Discussion

Ghaston's avatar
Ghaston
Helper I
7 years ago

rolling average by half hour

hi  i'm using power query to connect with a SQL base that refeshes every 5 min. I have a column named "Date_Heure" in the " Date/time " form.  I have a column named "Arche-Total_Entres" that i wan...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Ghaston,

 

That can't work. What's the type of column [Date_Heure]? Seems it isn't a DateTime type. Please check out. The error message is clear. We should check the data type and its values which should be a normal time. For example, 25: 30: 00 isn't a time. 

 

Best Regards,

Dale

Ghaston's avatar
Ghaston
Helper I
7 years ago


it's a date/time type

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Ghaston,

     

    The formula worked well in my test. Please refer to the snapshot below. Do you have any other details you can share?

    rolling_average_by_half_hour2

     

     

    Best Regards,

    Dale

  • Ghaston's avatar
    Ghaston
    Helper I
    7 years ago

    Well, i was trying to recreate the Dashbord in Import mode, so i can share it with you. And then, your code worked perfectly on the new Dashboard (import mode). 
    I don't know, why it didn't work on my Direct Query model, even though i'm using the same source file, and the data has the same type...

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Ghaston,

     

    Did you make it work? Do you use the latest version of Power BI Desktop?

     

     

    Best Regards,
    Dale