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.
Adjust matrix dates (in intervals) based on slicer selection
Hello, I have a Power BI report where I am using the Matrix Visual and have a date slicer. In the matrix, I have the Date value in the Column field. I need the dates to adjust with the dates selected in the slicer and also show in intervals of 7 days. I have tried binning the Date field into 7 days, but the last day shown in the Matrix is related to the latest Sunday, vs the last date selected in the slicer. I have also tried several dax formulas, but I can only get the last date shown in the matrix to correspond with the Maximum date in my data set. Any ideas on a formula that will allow me to show the Date field in the matrix in increments of 7 days and also display the last date that corresponds with the latest date selected in the slicer? (In my example below, the last date in the matrix should be 8/31 instead of 9/2). Here is the formula I am using to achieve this:
