Replacing BLANK with text in a particular period

[DearestYoki]

Hi all,

I am currently facing a issue of replacing BLANK with "No" inside my measure and only showing last 4 weeks value.   

What I want to display is actually W6, W7, W8, W9, and replace all blank values with "No".

The formula for Call is:

CALL L4W =

var lastvdate = [LAST VISIT DATE FOR ALL CUSTOMER]

VAR L4WSTART= [Last 3 Weeks No.]

return

CALCULATE(MAXX(Last_Call_Within_Route_Plan,Last_Call_Within_Route_Plan[Call_Visited_Flag]),Last_Call_Within_Route_Plan[VISIT_DT]>=L4WSTART && Last_Call_Within_Route_Plan[VISIT_DT]<=lastvdate)

If I use IF(ISBLANK([CALL L4W],"No",[CALL L4W]))

or COALESCE([CALL L4W],"No") Then all weeks are displayed instead of last 4 weeks.

Thanks & Regards,

Yoki

[v-shex-msft]

Hi @DearestYoki,

Can please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@DearestYoki , Try a measure like

0 between range
Measure = var _1= IF(ISBLANK([CALL L4W],"No",[CALL L4W]))

var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))