Forum Discussion
HELP with DAX
Hi dimidi ,
Here are the steps you can follow：
1. Select [Shift_Start] and [Shift_End] - Duplicate Column..
2. Select each of the two copied columns - Time - Time Only.
3. Create calculated table.
Time = VAR __StartTime= TIME(0,0,0) var __EndTime= TIME(23,0,0) var __Duration= TIME(1,0,0) return GENERATESERIES(__StartTime,__EndTime,__Duration)4. Create measure.
Time = VAR __StartTime= TIME(0,0,0) var __EndTime= TIME(23,0,0) var __Duration= TIME(1,0,0) return GENERATESERIES(__StartTime,__EndTime,__Duration)5. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi dimidi ,
Here are the steps you can follow：
1. Select [Shift_Start] and [Shift_End] - Duplicate Column..
2. Select each of the two copied columns - Time - Time Only.
3. Create calculated table.
Time =
VAR __StartTime= TIME(0,0,0)
var __EndTime= TIME(23,0,0)
var __Duration= TIME(1,0,0)
return
GENERATESERIES(__StartTime,__EndTime,__Duration)
4. Create measure.
Time =
VAR __StartTime= TIME(0,0,0)
var __EndTime= TIME(23,0,0)
var __Duration= TIME(1,0,0)
return
GENERATESERIES(__StartTime,__EndTime,__Duration)5. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous,
Thank you very much for your help. This is exactly what I need to achieve.
Many thanks again,
Dimitar
