Forum Discussion
Networkdays function with blank start dates
Hi Elisa112 ,
From the syntax I believe you are creating a column you can try something similar to this:
Meeting date diff= IF('Meetings'[1st Meeting]) <> BLANK(), NETWORKDAYS('Meetings'[1st Meeting],'Meetings'[2nd Meeting])-1)
MFelix Thank you, yes I am using calculated columns, I tried your function, it works but does not show the records with a blank start date, which I still need as there are other subsequent dates which need to be visible for the record.
Any Ideas?
Thanks in advance
In the first post you refer you want to ignore blank start dates, it seems like what you are writing in this last post is not matching that.
Can you please elaborate on what are the possible results with a example.
MFelix although I want to ignore any blanks in the 1st meeting column, I do need the dates for the 2nd and 3rd meeting for the customer, see example below of the output I need
Cust ID 1st Meeting 2nd Meeting Day Diff 1-2 3rd Meeting Day Diff 2-3
001 blank 1 Jan 2024 blank 5 Jan 4
002 blank blank blank 7 Jan blank
This is a summarised table, the original meeting table is very large and the meetings, have been ranked, therefore the 3rd meeting is the most recent.
Is there a way to show null if there is no date for the first meeting but still include the record in the table ?
Thank you in advance
