Difference between two columns (date & time)
Hello togehter, is there a way to calculate the difference in hour + / - between two columns? I have column with Date / Time where the ticket is opend, the second columune include the Date / Time SLA. So I need the difference, if the SLA is fall belows or they is exceeded. Many thanks for help.
Count working days of running month [Friday is weekend only] & Days elapsed
Hi Experts, Please help me out! Struggling to create a measure which will return total working days of current month dynamically [please note, Friday is only weekend in my organization]. I would also want to exclude holidays. I have a calendar table [see scrrenshot], now I want to calculate two measures 1. Total working days of current month 2. Days Elapsed = First Date of current month - Today () -1 [Excluding weekends and holidays] Thans in advance Mamun
Calculate date and time difference greater than one day - Help
Hi guys, I really need some help. I need to calculate the time difference between the dates, but it doesn't work when the time is longer than one day. Example : As you can see on the first line, the Store was inactive on the date of 09 08/22 and was active on the date of 11 08/2022, it also has its opening hours, where I only calculate the time that is within this time . In this example it was supposed to have a time of 19:40h but it calculates 39:40. I really appreciate if anyone can help me.
Using DATEDIFF in measure
Hello! I've spent some time attempting to use DATEDIFF in a dax measure but failed to do so. Here's the basics; I have two tables, "Sales" and "Stores". I am trying to display sales over time within a one year period and display the sales of store that have not been opened within that year. I also have a year slicer (which is properly working without the filter) like so: When I try to add the desired filter, the graph display: "Cannot display values". Here is my dax measure: Sales Filter = CALCULATE( SUM(Sales[sale]), FILTER(Sales, DATEDIFF(RELATED(Stores[OpenedDate]), VALUES( Sale[Date] ), YEAR) > 1 ) ) Thanks for the help in advance!Calculate Hour Type Column Difference
Hi everyone, I text you because I'm trying to calculate the difference between the hour values of the same column. The objective is to find the sum of time for every value of "Defensive Five" column: - To find the difference between the cell below and the one above grouped by another columns (Game and Quarter). I guess that I could use the DATEDIFF and LOOKUPVALUE but I'm not sure how I could use it bearing in mind that the Quarter starts witth value 10:00 and finish with 0:00. To make the comprehension easier, I add a pic of the dataset (the first one) used and the calculation in Excel that offers the expected result (the one I want to get in Power BI with DAX). The second one is a grouped sum after the calculation. Thank you for your time and your knowledge.
DATEDIFF only returning same value
Hi people, I am having the issue that my DATEDIFF returns the same value again (rather than the corresponding value from three months ago). The problem looks as follows: The dax command that I am using is here: Test = CALCULATE( sum('Table'[International Sales]), DATEDIFF( 'Table'[Date], -3, MONTH ) ) Can anyone please help me correcting my DAX so that it returns the figure for international sales from three months ago? I would require it in order to measure the growth of international sales within the last three months. Thank you in advance!
