Select specific date from table

Hello there. I have a column in my query field that is Date type. How could I create another column to be able to take selected date from first date table into the new column. For example I have d...

Need Help

Show and Tell

Tips and Tricks

amitchandak
4 years ago
Alexandra_B , You can use date table and time filter or both date and time table as filter. Assume date filter is all sorted

you can add time filter on a time column (have or create like)

Time = timevalue([Datetime])

calculate(Sum(Table[Value]) , filter(Table, Table[Time]>= time(8,0,0) && Table[time] >= time(16,0,0) ) )

or use time table to

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/