Forum Discussion
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], day))
VAR
Cal2= same as above with date field 2 and date field 3
VAR
Cal3=cal1-cal2
RETURN
If(isblank(Cal1)|| (isblank(Cal2)),BLANK(),Cal3)
Problem: when I am pulling this Value column in table visual, along with field 1,2,3; it is not showing any blank rows. So only showing rows where Value column has values. When I take Value column out, table shows all rows.
I could not find ‘show data within value’ option also
What I am doing wrong? Please help.
I tried creating measure also but getting same problem.
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], day))
VAR
Cal2= same as above with date field 2 and date field 3
VAR
Cal3=cal1-cal2
RETURN
If(isblank(Cal1)|| (isblank(Cal2)),BLANK(),Cal3)
Problem: when I am pulling this Value column in table visual, along with field 1,2,3; it is not showing any blank rows. So only showing rows where Value column has values. When I take Value column out, table shows all rows.
I could not find ‘show data within value’ option also
What I am doing wrong? Please help.
I tried creating measure also but getting same problem.
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 DiffCheers!
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
3 Replies
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 DiffCheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedInOn the dimension you have used try
