Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How do i create a column with variance?

There are many other questions like this but they always use months or day. For me, I want to calculate it hourly. I have 3 columns: canteen_location (text), hour (whole number, not summarised)...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , Create a separate table with distinct hours and join it back with hours

     

    Then you can have measures like

     

    This hour= CALCULATE(sum('Table'[number_of_people]),filter(ALL('hour'),'Date'[hour]=max('Date'[hour])))


    Last hour= CALCULATE(sum('Table'[number_of_people]),filter(ALL('hour'),'Date'[hour]=max('Date'[hour])-1))

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , Create a separate table with distinct hours and join it back with hours

 

Then you can have measures like

 

This hour= CALCULATE(sum('Table'[number_of_people]),filter(ALL('hour'),'Date'[hour]=max('Date'[hour])))


Last hour= CALCULATE(sum('Table'[number_of_people]),filter(ALL('hour'),'Date'[hour]=max('Date'[hour])-1))