If blank then zero works only in first grouping of matrix
I added this code to the measure. Date Range 1= var xy = CALCULATE(COUNTROWS('vw_ListNew')+0, 'vw_ListNew'[StatusDate] in VALUES(DateRange1[Date])) return if(isblank(xy),0,xy) it works for Date Range 1 and date Range 2, but when i add phase it still shows blank. Th
Data not refreshing web published reports
Hi, Hope someone can help me to resolve this issue. I am working with few dashboards, when I am publishing reports to the server some dashboards are not publishing/refreshing with new data and I am not getting any error message. Appreciate your suggestions to resolve this issue. Thank you.Expressions that yield variant data-type cannot be used to define calculated columns.
Hey Guys BIZ DATE = if(and(Format([ATD],"")=blank(),format([BIZ DAYS],"")=blank()),"", var dateidx = calculate( max('Calendar'[WorkingDayIndex] ) , 'P FILES'[ATD] = RELATED('Calendar'[Date] ) ) var newdateidx = dateidx + 'P FILES'[BIZ DAYS] return calculate( max('Calendar'[Date]), filter( ALL('Calendar'), 'Calendar'[WorkingDayIndex] = newdateidx && 'Calendar'[IsWorkDay] = 1 ) ) ) Data is company sensetive. I found a forum that suggested creating a calendar table to add days to a date and that seems to work (everything after the first line). However, the if statement will not seem to work. I understand that I am looking at two columns with different formatting (one is date and the other is text) I have tried using several combinations of value and format functions to no avail. I cannot change the formatting of these columns as their formatting is necessary for other calculated columns. I have tried making helper columns a little, but haven't had much luck. Also, the ATD column, which is date format, has blanks (null) in it. Any suggestions are appreciated. -Tad
