Forum Discussion

jac88's avatar
jac88
Icon for Helper II rankHelper II
4 years ago

How add Weekend for the Custom Title?

Hello,    I have created a custom title by combining "Primary Category" data. I need to add "WeekEnd" when it is Saturday or Sunday. I tried this using creating two columns below, but it did not wo...
Need Help
Show and Tell
Tips and Tricks
MFelix's avatar
MFelix
Icon for Super User rankSuper User
4 years ago

Hi jac88 ,

 

Try the following code:

 

Titles =
VAR NewLine = " / "
VAR Categoryvalue =
    CONCATENATEX (
        VALUES ( df_ProServUtilizationTracker[Primary Categories] ),
        df_ProServUtilizationTracker[Primary Categories],
        NewLine
    )
VAR Weekendtext =
    IF ( MAX ( 'VAR vCalendar'[WeekName] ) IN { "Saturday", "Sunday" }, "Weekend" )
RETURN
    Categoryvalue
        & IF ( Weekendtext <> BLANK () && Categoryvalue <> BLANK (), NewLine ) & Weekendtext

 

 

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    4 years ago

    Hi jac88,

     

    Did you tried my formula?

     

    The blank part that I use is only to avoid having the / on the measure if you don't have events.

     

     

    • jac88's avatar
      jac88
      Icon for Helper II rankHelper II
      4 years ago

      Hello MFelix,

       

      Thank you so much for taking look at this. Yes, I used the same formular. I can check the filter. 

       

    • jac88's avatar
      jac88
      Icon for Helper II rankHelper II
      4 years ago

      Hi MFelix 

       

      I have to change the filter direction and made a small change to your formula. So what I am trying to do is based on CalType, weekend days are different. For instance, "iMetaCal" weekends are Friday and Saturday. Rest is a normal weekend (Saturday and Sunday). 

       

      Somehow my one is not working the way I want. I

      Titles = 
VAR NewLine = " / "
VAR Categoryvalue =
    CONCATENATEX (
        VALUES ( df_ProServUtilizationTracker[Primary Categories] ),
        df_ProServUtilizationTracker[Primary Categories],
        NewLine
    )
VAR Weekendtext =
    IF(MAX(df_ProServUtilizationTracker[sp_Employees.CalType]) = "iMetaCal" ||  MAX ( 'VAR vCalendar'[WeekName] ) IN { "Saturday", "Friday" }, "iMETAWeekend", 
        IF(MAX(df_ProServUtilizationTracker[sp_Employees.CalType]) = "Standard" ||  MAX ( 'VAR vCalendar'[WeekName] ) IN { "Saturday", "Sunday" }, "Weekend"))
RETURN
    Categoryvalue
        & IF ( Weekendtext <> BLANK () && Categoryvalue <> BLANK (), NewLine ) & Weekendtext

       

      If you have a few more minutes, can you please take look at why my changes are wrong? I truly appreciate your help and time.  I am so close. 

       

      https://drive.google.com/file/d/1tM6gCCZlvoZou2fCs-l8jwG9SDQkRLuF/view

       

      Thank you 

      • MFelix's avatar
        MFelix
        Icon for Super User rankSuper User
        4 years ago

        Hi jac88,

         

        Tomorrow I will give it a look I'm without computer now, but I will pick this up ASAP. 

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    4 years ago

    I was looking at your model and since you have the bi directional filter it's not giving correct result I will check and get back to you