Forum Discussion
Select 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/
I have sorted it out.
Because I didn`t know how to create a table with specific date from another table, I just added two tables (Home - Enter data - table for School term, same for Half term).
Then, I went to Model to create relationship 1-* (see attached).
After that, I created the visuals I needed, with a slicer representing Days of the week, number of days and other required data. (Please note this is just from the data source I have and it is not complete, if you are checking the count of days 😁 )
I still have to work on design and edit some visuals, but at least I reached the main objective.
Thank you amitchandak for resources!
have a wonderful week ahead!
1-* relationshipHalf termSchool term