ashokchekuri
New Member
I Need to Calculate Network days using power pivot calculated fields.
My First Problem is Every column has Blank values.
Second Issue is that, I have to calculate the network days using three different date columns.
IF the first and second column has the non blank cells then I don't have to move forward. but if the second column has a blank Cell, then it has to move to last column and should find the network days between first and last column.
Please find the attached excel file for sample dataset. I am able to do it by creating some manipulated columns in the spreadsheet. However I would like to know, if we can create the same using the DAX in Calculated fields.
My First Problem is Every column has Blank values.
Second Issue is that, I have to calculate the network days using three different date columns.
IF the first and second column has the non blank cells then I don't have to move forward. but if the second column has a blank Cell, then it has to move to last column and should find the network days between first and last column.
Please find the attached excel file for sample dataset. I am able to do it by creating some manipulated columns in the spreadsheet. However I would like to know, if we can create the same using the DAX in Calculated fields.
Attachments
Last edited: