Forum Discussion
Helper IIISelect specific date from table
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/
Helper IIII was thinking maybe I create another table and create a relationship with the main Date table. It is possible to add multiple date range in the new table?
I now I can do like this :
New Date table = calendar(date(25/10/2021), date(29/10/2021))
but can I add in the same calendar more dates like 20/12/2021 - 04/01/2022, etc?
| 25/10/2021 |
| 26/10/2021 |
| 27/10/2021 |
| 28/10/2021 |
| 29/10/2021 |
| 20/12/2021 |
| 21/12/2021 |
| 22/12/2021 |
| 04/01/2022 |
| 04/04/2022 |
It is possible to create something like this , then create relationship with the main Date column?
Thank you.