Great videos Ruth. I am hoping you will do a follow up video on using date diff as a measure rather than a calculated column. Calculating dynamically based on date criteria (ie max(date), by using your examples (values or lastdate function) around11:00 of this video.
Thank you very much Ruth for the great explanation. Was looking exaxtly for DATEDIFF but any recommendation when the two date are in different tables? Your help is very appreciated.
@11:22 - In the 3rd Row your order date is 29 July 1996 and your shipped date is 6 Aug 1996. The value that returns from the Datediff (months) function is 1. How is that possible? Since one full month hasn't crossed between two dates
Is there a way for DATEDIFF to show decimal places? ie between 1.01.2021 and 15.02.2021 DATEDIFF returns 1, how to make it show 1.5? I'm thinking about let's say 1mothn deadline. Tasks starts on 15th February, is finished on the 20th March. DATEDIFF shows 1 month, but in fact the task wasn't finished on time.
Hi Ruth, Can you please help , i have two different dates, "Triage Date/Time (dd/mm/yyyy hh:mi)" and "Registration Date/Time (dd/mm/yyyy hh:mi)" i have to to find how much time it took to get registration? Only need to find time.
If it would be possible to explain how to create a measure calculating the sales amount difference between current day and previous day that would help me so much
Hello, I was calculating the time difference between two dates( the dates were in the format "DD/MM/YYYY/HH/MM/SS) and using your method I still wasn't able to calculate the difference in time. The dates were starting time and end time of different resources that are being used by the students. Please help, I would really appreciate Thank You, Kumar Ashwarya
+kumar ashwarya Difficult to say without seeing the data. Have you seen this; community.powerbi.com/t5/Desktop/Calculate-difference-between-two-date-time-values/td-p/71841 The best way is posting your question in the power bi community with sample data. RU-vid is not optimal for this. /Ruth
gracias!! muy útil, tengo una pregunta, a ver si me puedes redirigir a otro vídeo :). ¿Cómo introducir en el switch un condicional como "si la shipped date está vacía, DATEDIFF(required date, CURRENT DATE, day)"? Millones de gracias!
Hi!!!long time teacher!...I wanted to ask you something related to an advanced dax for counting minutes between start time and end time avoiding weekends and holidays and... considering hours from 9am to 17pm? I did it in excel but no much clue to do it in power BI..any advice would be really well recieved...Greetings and thanks again for your fabulous channel!!!! excel example that is working pretty good is:(=SI(O($B$2
+Cristian Dominguez Hi Christian!! Have you checked the NETWORKINGDAYS and TIME Dax Fridays videos? You can find them here: Https://Curbal.com/blogglossary /Ruth
Hi Ruth, my date table has continuous dates, say from 2007 to 2025 and the fact table will say has dates from 2014 to 2018. I want the slicer to show only the years from 2014 to 2018 as per the fact table. Thanks
Maybe this will help you, if it doesn’t, please comment on that thread: community.powerbi.com/t5/Desktop/Visual-level-filtering-for-slicers/td-p/21323 /Ruth
i have a column of plan finish date now its already due date so i wana make new column of age that just show the age of that by following below formula According to risk warning over due days= plan finish date-today or a current date over due days between 28-21= age with -3 to -4 over due days between 21-14= age with -2 to -3 over due days between 14-07= age with -2 to -1 over due days between 07-0= age with -1 to 0 how i can write its query or calculation what i wat i want to need four columns of differenrt weeks ages as shown below secondly i need total age of a week that will be due from plan date for example task or a plan due date is 22/05/2018 and today date is 29/10/2018 so how i can calculate total weeks inthis duration with the help of formula
+Roberth rodriguez chacon El equivalente no existe en DAX, pero este artículo describe como lo puedes calcular a mano: powerpivotpro.com/2012/11/networkdays-equivalent-in-powerpivot/ Haré un vídeo sobre esto ;) /Ruth