Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more. Hi @Slickyworm , you can try this. I am new to Power Bi and dax and I would like to calculate a datediff in weeks between the max date in one table and dates in another table. From ( [Date 1]) When Date 1 y the date with hours, and Date 2 is the normal date (without hours). The Power Platform community, they note, is a wellspring of resources and opportunities, fostering continuous learning, skill enhancement, and. The result is a number from 1 to 7 indicating which day of the week it is. From([startDate])) ) If you already have Date values, not DateTime values, you can remove the Date. It is as below. A date in datetime format that represents the start date. When using multiple calls to GetDate(), whether in a single. There’s some great documentation here that I strongly recommend you read, but in a nutshell query folding refers to how the Power Query engine inside Power BI can push calculation and transformation logic back to whatever data source you’re using in the form of a query – for example a SQL query if your data source is a relational database. . Days function in Power Query: = Table. Dates (StartDate, Number. The following works for days difference between DateTime values folding against SQL Server: Table. Actually opens my mind to some other difficult ways to simplify the flow with sharepoint list contents. For example for someone born on 30/12/1999 the age gets returned as 18 where obviously it should be 17 as todays date is 09/09. If you plan on using this in a table or graph, using the function "Selectedvalue" will add the current context. SelectedDate, Days) / 7, 0) And then the difference of the days not in the whole weeks. These two dates represent the start date and the End date of projects. To do this, we need to create a calculated column using the DATEDIFF DAX function as seen in the diagram and DAX syntax below. I want to create a new measure, cannot create columns, that will do a datediff between the two but can't seem t. Power Query; GCC, GCCH, DoD - Federal App Makers (FAM). It does exactly what you would expect: calculate the amount of time in between two dates, and express that value as either seconds, minutes, hours, days, weeks, months, quarters or years. First, the logic: 1: Do a straightforward DateDiff for Years. What I would like power bi to do is lable any row in resolved date column that is blank with the text "open" This way I know the ticket is still open and has not been resolved. Date. Power Query; Mobile Apps; Developer; DAX Commands and Tips; Custom Visuals Development Discussion; Health and Life Sciences; Power BI Spanish Community;. @wuhao0506, Do you use Power BI Desktop August version ?Based on mye test, even we enable unrestricted measures, it is not possible to use DATEDIFF function in calculated columns in DirectQuery mode. 0. The reason for the error-message is that you aim to compare Date with DateTime-values. The difference between 01/01/2019 01/01/2020 would be 12 months. The source code for my Power Query function to compute the ages is shown below. So to get Days it would be. The syntax of Power BI DATEDIFF is: “DATEDIFF (, , )”. BR, Alon You have to use M functions rather than just pasting in SSRS code and hoping it works. Logic 1: IF the column Proposed Complete Date does not contain Good and ART and 2021 and 2020 then DATEDIFF([Today Date],[Request Date], DAY). @Anonymous , You can subtract and add Days date without any function. For example, I have a following product report, if the product status is Old, displaying a 50% discount; if the product status is New, displaying a 20% discount as below screenshots shown. Power Query; GCC, GCCH, DoD - Federal App Makers (FAM). let // calculates a duration between two timestamps in working hours fnDurationWorkingHours = (StartDateTime as datetime, EndDateTime as datetime) as duration => let // start and end date StartDate = Date. 03-09-2021 09:06 AM. 09-23-2021 06:57 AM. Measure does not belong to any table. Message 2 of 2. Power Query; GCC, GCCH, DoD - Federal App Makers (FAM) Power Platform Integration - Better Together! Power Platform Integrations;. I am trying to calculate the time it takes in minutes for an action to be completed. UCHKANA. Hi there, I have two date-time columns. TotalDays([EndDate]-[StartDate])/30 . The function requires a list of holiday dates so I amended the table you had so that each date is listed on its. Selected. In "Tasks" data base, I click on "Add Column" tab and "Custom Column" icon. TimeDiff = SUMX (Table, Table [TimeColumn1] - Table [TimeColumn2] or. To determine the current time in UTC, use: DateAdd ( Now (), TimeZoneOffset (), TimeUnit. If the Date column in SP list less than Current Date then allow to triggered something. Then, go into the Power Query and under New Source, open up a Blank Query. I want to calculate the difference between "SLA1 Time" and "when item is created" and stored this difference in another column named "SLA". Description. IsInPreviousWeek, and Date. Thank you,One of the most useful new additions to DAX in Excel 2016 and the Power BI Designer is the DateDiff () function. If Datediff Start,End<=14 then. /* FUNCTION: Emulate Excel's DATEDIF. It does have Duration, but this only for days, hours. Im wanting to find the total minutes between start and finish times (data in 24hr format) using time values only. Days ( [2nd Date]- [1st Date]) to give you the number of days between 2 columns. You can do this by using a measure that calculates the maximum date in the column. Here is how it works: Day of Year = DATEDIFF (STARTOFYEAR ('Date' [Date]),'Date' [Date],DAY)+1. 04-12-2022 01:25 PM. 1 = Table. The workbook contains an example of applying the function. ‘ NETWORKDAYS ’ is used to return the whole number of working days between two dates (inclusive). Steps for achieving your required output: Step-1: In Power Query Editor, first create a custom column to generate the actual date formatted value from START. The script is as shown in the image below-. my output is as follow: Now I only want to check the DateDiff between those rows where the UserFieldName = Status. I have the following that. Selected. I am using the formula: DaxTest11 = DATEDIFF('table'[Date/Time Opened],'table'[First Response],MINUTE) returns odd results in a new column I added to the dataset. This can be in either days, hours, minutes, months, quarters, seconds, weeks or years. Interval is the unit of time intervals this function returns. Select which requires a list as its first parameter and then a condition as its second parameter. Days Elapsed = CALCULATE (DATEDIFF ( SELECTEDVALUE (Projects [entry_date]), SELECTEDVALUE (Projects. I tried to apply both your porposals, but still not there yet. 1)I need to find the difference in minutes between the rows of "DateTime" column. This will help others find it more readily. Reply. Here's a possible implementation in M in the style of this post. The Power Platform community, they note, is a wellspring of resources and opportunities, fostering continuous learning, skill enhancement, and. So for example the DateDiff output for "01. Days formula in the Power Query editor , or avoid custom formulas altogether by using the Power Query Column from Example feature. If I use Datesbetween function to count the rows in the Date table filtering out weekend days, it works fine only if start date is less then the end date. Selected. -- 2018-01-01 is a monday SELECT DATEPART (WEEKDAY, '2018-01-01') -- Result: 2. I have figured a measure to get the DATEDIFF between the Earliest and Latest Dates within the same column, if the state is "Closed Complete", by RPA #. i have attached the snap of the cell. Can't create datediff measure. Your solution: agetest = FLOOR(DATEDIFF(date(2017,02,05), date(2020,02,05), DAY) / 365. @JKoivu , diff from previous date . In "Tasks" data base, I click on "Add Column" tab and "Custom Column" icon. However, I can't get the column's formulas to update on ther Power BI Service. =Datediff (Today (),AR [DATE],Day) Solved! Go to Solution. In the filter query, I want to compare 2 dates like I have date column in SP list and Current date. When i want to use a Date column in this mode it shows as a Varchar/string type. I found a post to do the hours and minutes which works, but I tried to keep the same format and add seconds but it's not working as expected. @ me in replies or I'll lose your thread!!! Instead of a Kudo, please vote for this idea. Next, I tried creating a column using formula below . Power-BI DATEDIFF from 2 different dimension tables, related to fact table. Here will see how to get the current date or today’s date using the Power Query editor in Power BI. From the merge, extract the [Change Date]. The following DAX query: I need to find the month difference between two dates (checkIn and Checkout dates) in Power Query (M-query). 4. go to Add Column Tab, under “From Date & Time” section, and under Date, select Age. How to Calculate Date Differences Between Two Dates in Power BI. LocalNow ()) - [Your Date Column] ) In DAX you can add a calculated column and use this formula. Diff = DATEDIFF (MAX (Table1 [Date Scanned]), Table2 [Date Scanned], DAY) Again, you really should append those tables, in which you will then need a different expression. If within the same year, you can use Date. If I. What I need to do is to calculate difference between Date_Completed and Date_Created, but not for row 1, row 2, etc - I would use DATEDIF function, but rather like this: Date_Created (task_id = 2) MINUS Date_Completed (task_id=1) ====> y- (x+1) I try to use EARLIER function to return me Date_Completed in a newly calculated column. From(StartDateTime), EndDate = Date. 05-28-2018 09:40 AM. Not sure about your syntax here, I believe your formula should be: NoDays = DATEDIFF ( [Actual Response Date], [Target Response Date], DAY) Actual Response Date and Target Response Date should be a Date/Time format and NoDays should be Whole Number. If the content was useful in other ways, please consider giving it Thumbs Up. Days. 11-20-2020 12:34 PM. i created a calculated column for an age in months as follows: No of months old = -DATEDIFF (TODAY (), '01_Calendar' [Date], MONTH) It works out the value correctly for me. Power query current date. ISBLANK('Internacao Deint' [Data Alta]), TODAY()-'Internacao Deint' [Data Entrada],Explanation of the formula -. So, to do it, just navigate to the Data view, select the table containing the date whose difference you want to find and click on the New column option. @RonRosenfeld You are right. In the function below, if the start and end dates are between Monday and Friday (weekdays from 2 to 6), their difference will be in the -4 (start on Friday. since i need it in hours. (when date 1 is the earliest date and date 4 is the latest date). Here is a Power Query custom function to calculate the number of business (networking) hours between two dates. 前回記事のおさらいは、. Run (DateDiff (Today (),DateValue (Gallery6. Hi @roebern. We will discuss the emergence of generative AI and how we are changing the way makers build and use Microsoft Power Apps with the support of Copilot. AddDays(StartDate,2) els. Yes to your first question. The syntax for DATEDIFF DAX function is: = DATEDIFF (Start Date, End Date, Interval) Start Date: The date you want to count the difference from. You can follow the below steps to get the number of days between date_entered and exported_date: 1. Measure does not belong to any table. In "Tasks" data base, I click on "Add Column" tab and "Custom Column" icon. TotalMinutes ( Durationvalue) Share. Building a model lets you tap into many functionalities within Power BI-like visuals, Power Query, and DAX calculations. Calculating difference between two dates in weeks in an if statement. DATEDIFF in DAX doesn't have a concept of whole months, it simply counts the number of boundaries crossed between the two dates, so DATEDIFF ( DATE (2018, 2, 28), DATE (2018, 3, 1), MONTH) returns 1 because 1 month boundary has been crossed, even though there is only 1 day. Adds timezone information to the datetime value. With this table loaded into the Power BI. Value = "Work", DateDiff ( DateTimeValue (DataCardValue33. What I would like power bi to do is lable any row in resolved date column that is blank with the text "open" This way I know the ticket is still open and has not been resolved. Syntax: NETWORKDAYS (<start date>, <end date> [, <weekend>, <holidays>]) Unlike the function DATEDIFF, you can edit parameters to specify which and how many days are weekend days. Power BI DAX filter-specific date Let us see how we can apply the filter of the data tables only to the specific dates or the selected dates using the Power Bi Dax formula in Power BI. DATEDIFF([Hire Date],[Report Date],YEAR) But how can i get the equivalent of the Excel "YM"? If i do the same formula as above with the MONTH interval, i will get the total number of months from one date to another. 07-01-2020 06:10 AM. Substitute the big number with 36000000000 and you will get hour difference, 600000000 minute difference, 10000000 difference in seconds. Our hope is that this information will help each of our community members grow in their. it gives me expected value for average of Datediff but here the problem is everytime I should go to edit parameter and choose the. so a date this month would be 0 a date last month would be 1 ect. Days ( duration as nullable duration) as nullable number About Returns the days portion of duration. You just expand this column as you need. Previously, we calculated the current date using the NOW function. Get Help with Power Apps; Power Query; DATEDIFF function with Filter; Reply. A date in datetime format that represents the end date. Measures are a DAX/Power Pivot term. 04-21-2020 10:48 AM. Power BI July 2022 Feature Summary. Power query add column datediff Here we will see how to calculate the difference between two dates to calculate the days count using the Power Query editor in Power BI. Tip: GetDate() is treated a bit oddly in queries. Usage Power Query M Duration. Hi Im trying to find out how to create a new column that contains the duration between two dates. Cách hiển thị lỗi chi tiết cho các dòng trong Power Query Power BI. LocalNow ()) and give a name to the new Column in the. All you need to do is just copy and paste this code into a blank queWith this new value, you can now calculate the difference between the date of the current and previous row. TheDate = InputBox ("Enter a date") Msg = "Days from today: " & DateDiff ("d", Now, TheDate) MsgBox Msg. 11-01-2018 06:16 AM. RELATED('Table 2'[Action Date]). While i use datediff but it shows half negative and half postive integer values. Value), DateTimeValue (DataCardValue34. The solution worked perfectly. TheDate = InputBox ("Enter a date") Msg = "Days from today: " & DateDiff ("d", Now, TheDate) MsgBox Msg. Calculate table with max date and max value from other table. Determine various quarters ran based on start and end date in google sheets. A date in datetime format that represents the end date. I am trying to create categories based on the amount of time difference between the two dayss ie. Hours(Duration. I am trying to return the number of minutes it takes to respond to a case. In response to Anonymous. This example uses the DateDiff function to display the number of days between a given date and today. To calculate the datediff between the latest date and today in your table visual, you'll first need to determine what the latest date is. Power Virtual Agents. However, you can create a measure instead. Result and complete code. See the example below. Power BI. I can't imagine there's a much easier way because we simply don't have the logic in Power Query M for a DATEDIFF equivalent. The first option you advised is something I have already tried via Add Custom column in Power Query. need to find new rows based on the date with DAX in power BI. DateDiff( Date(2020,1,10) + Time(12,0,0), Date(2020,1,10) + Time(14,0,0) Hours ) If you want more guidance than this I would suggest you share a screenshot of your app's interface so I can replicate it. In this article Syntax Duration. From([End]-[Start])) for my data. One of the most useful new additions to DAX in Excel 2016 and the Power BI Designer is the DateDiff () function. Step 5: Change Sort column. I'm looking to find a way to do a DateDiff Formula to determine if a rep has been trained. Days (#date (2022, 3, 4) - #date (2022, 2, 25)) Output 7 Learn more about: Duration. Then count the number of days left in your list. In addition to other posts, you can also use the following formula to calculate the difference between two datetime values even though there are in inconsistencies in the database. From([End]-[Start])) for my data. 2: Add Years to the start date, so you can then get the remaining months. Text),Days) View solution in original post. (see below): and my custom column has the the if and else statements as follows. Power Apps. You need to combine your DateDiff DAX with IF. The first piece of M code generates a table containing two columns, you can use for practice - just paste that into a new blank query. Is there any way this can be accomplished in Power. 2 - paste my code. Power Pages. We want to see, how many hours was the item on stock. GCC, GCCH, DoD - Federal App Makers (FAM) Power Platform Integration - Better Together! Power Platform and Dynamics 365 Integrations. Once you compare date/times of the same type, it's as easy as in Excel:Excel 2016 or later for Windows and Microsoft 365. Ok, enough preaching. 1. Working Days between Dates in Power Query (DATEDIFF) Updated on November 17, 2023 0 Power Query Written By Rick de Groot Rick is the founder of BI. Or perhaps they were thinking of the DAX DATEDIFF function. DATEDIFF – difference between two dates or times in units you need. Step-2: Change the data type of newly created column as date time and the output will be as below-. RoundDown (DateDiff (StartDate. Time Taken = DATEDIFF (Sheet1 [Start Time],Sheet1 [End Time],MINUTE)After my test, you could do these follow my steps as below: Step1: Add a group rank column. Solved: Im New to power BI and need help in translate excel formula below into a calculated column The formula calclates working period between two. Nov 19, 2021 at 15:36. 1-7 days = 1 week tenure 8-14=2 week tenure, etc. Just replace it with minutes and divide by 60. Date Diff = DATEDIFF ( Dates [Order Date], Dates [Ship Date], DAY ) The DATEDIFF function is used to calculate the difference between both dates. I need to calculate the difference between two date and time values in the "Excel way". I am trying the create a function that replicates the Workdays function typically found in Excel. The formula I. As column . group rank = RANKX (FILTER (Table1,Table1 [Trackingtocken]=EARLIER (Table1 [Trackingtocken])),Table1 [createdon],,ASC) Step2: Use EARLIER Function add a datediff column. 09-30-2022 02:52 AM. Days ( DateEnd - DateStart ), // The number of days should create a series that begins at. Etc. LocalNow function. For both functions, units can be. Days (endDate - startDate),. I want to have a measure or columns on events that would hold the age the person was when the event occured. datediff into power query. You can write Power Query formulas. Not sure if this works but looking for any way to get this to function. TimeDiff = SUMX (Table, DATEDIFF (Table [TimeColumn1], Table [TimeColumn2], MINUTE)) If you make a table visual with both time columns, you should see the difference when you add. View solution in original post. To see the result, use the Text function with the format dd-mm-yyyy hh:mm, which will return 15-07-2013 20:02. Hi Imke Feldmann, I tried with the expression above Duration. Days (DateTime. Get Help with Power Apps; Power Query; Date difference between two different tables colum. DATEDIFF is available in DAX but not in Power Query Editor. = DATEDIFF (Orders [Order Date],Orders [Deliver Date],HOUR) Date 1 –. 0. In response to Anonymous. Função DATEDIFF no POWER BI | Calcular Diferença entre Datas [Passo a Passo]Curso de POWER BI Gratuito vídeo você aprenderá de du. How to create datediff calculation in Power Query. Call it [Sales Date]. Change the type to DateTime. Step-3: Now order column ID first ascending. In Power BI, I have found the correct formula to calculate the year so it returns 3 years. I do the same in T-SQL using the following query DATEDIFF(dd, Date1, GETDATE()) - (DATEDIFF(wk, Date1, GETDATE()) * 2) - CASE WHEN DATEPART(dw, Date1) = 1 THEN 1 ELSE 0 END + CASE WHEN. Duration data is rarely helpful in any visualization so we have to convert duration data to units like Hours Minutes & seconds to get the best use from it. Dim TheDate As Date ' Declare variables. Solved! Go to Solution. chiibosoil 293 • 2 yr. This function calculates the difference between two dates in the specified interval, such as days, weeks, months, or years. Duration. 4 - include this function in your querry - example. From,. [Date];List1 [Date 2]. I have a measure called Days elapsed that looks at the number of days that have passed. 07-05-2020 07:30 PM. Please try this formula: If (DataCardValue42. Now add a custom column in query editor and write the expression as below =networkdays([Start],[End]) – Step 4: Change Data Type. Learn how to use duration functions in Power Query M to create and manipulate duration values. The key here is that you need to do each calculation recursively based on the previous calculation. Click on the modelling tab-> New column from the ribbon in power bi desktop. Simply copy the M code from her blog. I need to show the "days to expire" in a matrix-visual so I tried to make a DAX formula as it goes trying to get the "days to expire" from each product and it's expiration date uniquely, but the result was way far from what i wanted. E. , endDate:DateValue("2022-02-14") }, RoundDown(DateDiff(startDate, endDate, Days) / 7, 0) * 5 + Mod(5 + Weekday(endDate) - Weekday(startDate), 5) + 1 ) The caveat with this formula is that the start and end dates must not be weekend dates. How to perform a DATEDIFF for POWER QUERY? The code to build your custom Power Query function is in this article The code for each calculation Collec the code for each calculation returns by the. You just expand this column as you need. And the difficulty lies exclusively in DATEDIFF transforming thousands of lines in days, communicating with the Bank in DQ. I did it with the following change in the DAX: Dif between previous index =. I want to calculate the difference between two date-time columns and return the result in minutes as third column in query editor. For 2 and 3 I'll just drop this blog here so you can read the details. technically i should date and time right9,508 Views. Thank you for your reply, the formula you shared returns the format I was looking for, but when I try to calculate the difference between two dates ( date1= (2020;5;1) date2= (2020;5;2)) where the the difference is only 1 day the returned result is totally different -1 year, 11 months and 1 days. 10-28-2018 10:45 PM. PowerAppsDay1. Message 1 of 3. Here's an example in Power Query M language: let startDate = #date (2019,1,1), endDate = #date (2023,12,31), durationInDays = Duration. In the file column showing whether the corresponding date is a weekend, or not, contains the below expression: =IF (WEEKDAY (A2,2)>5,FALSE,TRUE) Then I simply used the “DATEDIFF” function and after subtracted number of days/ hours/ minutes according to number of weekends that had occurred between the dates. DATEDIFF( date_part , start_date , end_date) Code language: SQL (Structured Query Language) (sql) The DATEDIFF() function accepts three arguments: date_part, start_date, and end_date. As column . Click on the modelling tab-> New column from the ribbon in power bi desktop. That’s it. I have a start date and time and an end date and time and I'd like to use DateDiff() to determine the hours:minutes:seconds of elapsed time. select dim_calendar. TimeDiff = SUMX (Table, Table [TimeColumn1] - Table [TimeColumn2] or. CycleDate,Days) but its showing a negative symbol -11. From([EndDate]-[StartDate]))) Did I answer your question? To calculate the number of days between two dates using DAX, use the DATEDIFF function. DateDiff in Hours = DATEDIFF(MIN(B),MAX(B),HOUR) View solution in original post. The reason is that the unit you use when calculating is 'hours'. I have gotten so far; //fnWorkDays let func = (StartDate as date, WorkDays as number) => let WorkDays2 = (WorkDays*2)+7, StartDate = if Date. Regardless of which method you decide to use to calculate the difference. Data Example: Date/Time First. The difference between 01/01/2019 01/01/2020 would be 12 months. Days(Duration. It is very strange- in query editor, it seems to give correct values. Here, I will introduce how to use this if statement in Power Query. In Power Query Editor go to Add column tab -> select the Custom column from the ribbon. SELECT DateDiff ("yyyy",#01/01/2010#, [DateofSale]) AS Expr1 FROM ProductSales; Returns the difference between Date2 and Date1 (consider Date1 as oldest and Date2 as. Thanks to the PowerAutomate Gods. Please help me to find days between column date and today, i tried below code in custom column function but DateDiff is not recognised code. In this table, I flagged everything that is a weekend, holiday or time outside the workschedule within Power Query so I can easily filter these values with DAX. TotalMinutes needs to be a duration. Now in the power query editor, you need to add a new custom column, so go to Add Column > Custom Column. It's a bit more complex but replicates the DATEDIFF function for the M language: How to perform a DATEDIFF for POWER QUERY? The code to build your custom Power Query function is in this article The code for each calculation Collec the code for each calculation returns by the DATEDIFF function Write the code into a custom query Create custom queries to copy your code Call your custom function Learn how to use date functions in Power Query M language to create and manipulate the date component of date, datetime, and datetimezone values. Stack Overflow Public questions & answers; Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Talent Build your employer brand ; Advertising Reach developers & technologists worldwide; Labs The future of collective knowledge sharing; About the companyHow to create datediff calculation in Power Query. It appears to take fractional parts of the days and if there is more than half a day remainder, round up the result, which looks like there is an extra day. Basically what i would like to do is have an access query that calculates the date difference for consecutive records but for the same account number The expected result would be !!. Click on any table field/column. 2: Add Years to the start date, so you can then get the remaining months. ) Important: Retirement of Facebook data connector notice Import and refresh data from Facebook in Excel will stop working in April, 2020. Here is how you can use the Duration. In this example, 0 is returned because the start date is a Saturday and the end date is a Monday. In the function below, if the start and end dates are between Monday and Friday (weekdays from 2 to 6), their difference will be in the -4 (start on. Microsoft's Power BI works as the ultimate power tool for data analysis. In this video, we explained How to calculate difference between two dates in Power Query of Power BI. A single value for column 'DateOfBirth' in table 'Contacts' cannot be determined. Then write the Dax formula: No. Hi PBI Experts, We have two different tables Tabele1 and Table2 in that table i need find Caluclated Column dax function for Date diffence between two tables (Joining date and Action date along with filter is Action Type = "Termination"), Here need to find Date difference (Joining date and Action date) and also apply the filter Action Type. Try wrapping those columns in an aggregate function like MAX in order to get a single. I've got a table with a date field in it called install_date. Date2. Now, this is done in the Power BI interface. Date Diff = DATEDIFF ( [OrderDate], [ShipDate], DAY ) With this simple syntax, you can return a column that calculates the difference between two dates. AddColumn (#"Removed Columns", "PKG. Filter query between date. How to get values in PowerBI between two dates in two different columns. Returns the days portion of a duration. Community Support. Value = "Work", DateDiff ( DateTimeValue (DataCardValue33. Syntax: NETWORKDAYS (<start date>, <end date> [, <weekend>, <holidays>]) Unlike the function DATEDIFF, you can edit parameters to specify which and how many days are weekend days. SelectRows (fechas, cada (fechas [date]> = [Event_start_date] y fechas [date]<= [Event_end_date. 4: Add Months to the start date so you can get the remaining days. Webinars and Video Gallery. The first option you advised is something I have already tried via Add Custom column in Power Query. The result is a whole number of units. Select date column for NETWORKDAYS function. StartOfMonth and the DateTime. I have a column of "SLA1 Time" in list and this time is stored in a list when approver approves the task. If you subtract a date from date, it will return diff in term of timestamp.