Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated column not showing blank rows

Hi I created a calculated column using following Dax Value= VAR Cal1=if (isblank(table1[date field1))|| ( isblank ( table 1[ date field 2])), BLANK(),Datediff( table1[field 1],table1[date field2], ...
Need Help
  • vivran22's avatar
    vivran22
    6 years ago

    Hello Anonymous 

     

    You may try this:

    From the drop down option of ID column > Select Show items with no data

     

     

    For this, I have created the calculated column as per your scenario:

     

    Column = 

VAR Col1 = IF(
            ISBLANK(Sheet1[Date 1]) || ISBLANK(Sheet1[Date 2]),
             BLANK(),
             DATEDIFF(Sheet1[Date 1], Sheet1[Date 2],DAY)
            )
VAR col2 = IF(
            ISBLANK(Sheet1[Date 2]) || ISBLANK(Sheet1[Date 3]),
             BLANK(),
             DATEDIFF(Sheet1[Date 2], Sheet1[Date 3],DAY)
            )
VAR Diff = IF(
    ISBLANK(Col1) || ISBLANK(col2),
    BLANK(),
    Col1 - col2
)
RETURN
Diff

     

    Cheers!
    Vivek

    If it helps, please mark it as a solution
    Kudos would be a cherry on the top 🙂

    https://www.vivran.in/

    Connect on LinkedIn

vivran22's avatar
vivran22
Community Champion
6 years ago

Hello Anonymous 

 

You may try this:

From the drop down option of ID column > Select Show items with no data

 

 

For this, I have created the calculated column as per your scenario:

 

Column = 

VAR Col1 = IF(
            ISBLANK(Sheet1[Date 1]) || ISBLANK(Sheet1[Date 2]),
             BLANK(),
             DATEDIFF(Sheet1[Date 1], Sheet1[Date 2],DAY)
            )
VAR col2 = IF(
            ISBLANK(Sheet1[Date 2]) || ISBLANK(Sheet1[Date 3]),
             BLANK(),
             DATEDIFF(Sheet1[Date 2], Sheet1[Date 3],DAY)
            )
VAR Diff = IF(
    ISBLANK(Col1) || ISBLANK(col2),
    BLANK(),
    Col1 - col2
)
RETURN
Diff

 

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Thanks a lot.
Super silly me! I was looking for show items with no data for value field only , not other fields.
Seeing your ID field made me realize that
Thanks
Thanks