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,

 

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. 

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

        Hi MFelix ,

         

        Thank you so much for your hlep. I just wanted to know why my changes to your formula are not working. It's showing every day now. 

         

        Again, thank you

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

      Hi jac88 ,

       

      You need to use an AND statement on your weekend part and also add a next level of IF to mark all the weekened values try the following:

       

      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
    IF (
        MAX ( 'VAR vCalendar'[WeekName] )
            IN { "Saturday", "Friday" }
                && Categoryvalue
                    & IF ( Weekendtext <> BLANK () && Categoryvalue <> BLANK (), NewLine ) & Weekendtext
                    = BLANK (),
        "Weekend",
        Categoryvalue
            & IF ( Weekendtext <> BLANK () && Categoryvalue <> BLANK (), NewLine ) & Weekendtext
    )

       

       

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

        Hello MFelix 

         

        Sorry to be a pest, and thank you so much for the quick response. This is almost perfect, but there is a small issue. For instance, "iMetaWeekend" is Friday showing all the way for all employees. I only need to show employees with the Calendar type "iMetaCal".


        Do you know by any chance, how to do it by the employee? One last thing, Sunday is not showing as a weekend. Try to find out why is that, but no luck so far. 


        Again, thank you so much