Forum Discussion
Measure Help - Average Hours a Week Grouped into Buckets
I have the following table with the following columns Time: Emp ID | Date | Week | # of Hours Charged Data goes back 10 weeks Week =Time[Date] - weekday(Time[Date],2) +1 Ive been asked to cr...
Here is Switch conditon to use also if we need any kind of week like 7 days or 10 days bucket link in our report then we are used only rhis dax.
First we make days in our Date field then we calculate the all of weeks count to sort of data field.