data per time slot

[ayoubb]

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

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,"")

[amitchandak]

@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://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-bucket...

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

[ayoubb · Accepted solution]

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

[ayoubb]

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