Forum Discussion
data per time slot
Hello,
Please i want to change this DAX below, in order to show me data every 30min instead of every 1hours
i want to see the graph below with;
00 - 00:30
00:30 - 01
01 - 01:30 .................. etc
Hello amitchandak,
thank ou for your reply,
thus, is there any way jute to change this column below, insteady of showing time slot in hours like this 00-01, i want to to be in half hours 00-00:30 and so on
Genesys par tranche horaire = VAR timeslot = FORMAT(HOUR('SEPHORA'[Call start time]),"00")&"h-"&FORMAT(HOUR('SEPHORA'[Call start time])+1,"00")&"h" return if(HOUR('SEPHORA'[Call start time])>=00 && HOUR('SEPHORA'[Call start time])<=23, timeslot,"")
ps: what you asked me to do is very complicated for me
3 Replies
ayoubb , You can create a time table and there you can create a 30 Min bucket and join it with your time
In case you date and time together have time column
Time = [datetime].time
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
Hello amitchandak,
thank ou for your reply,
thus, is there any way jute to change this column below, insteady of showing time slot in hours like this 00-01, i want to to be in half hours 00-00:30 and so on
Genesys par tranche horaire = VAR timeslot = FORMAT(HOUR('SEPHORA'[Call start time]),"00")&"h-"&FORMAT(HOUR('SEPHORA'[Call start time])+1,"00")&"h" return if(HOUR('SEPHORA'[Call start time])>=00 && HOUR('SEPHORA'[Call start time])<=23, timeslot,"")
ps: what you asked me to do is very complicated for me
Please i need to create Heatmap (using matrix visual) to show all timeslots (from 00-00:30....,23:30 - 00) for 24 hours (with 30min gaps), i need to calculte how many calls we have received in which time slots.
this the date base:
Thank you for your help
