Forum Discussion

jac88's avatar
jac88
Helper 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
jac88's avatar
jac88
Helper 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
Super 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
    Helper 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
      Super User
      4 years ago

      Hi jac88 ,

       

      The issues are related with context that is giving an incorrect result because of the many to many relationship you have, so in this case the Calendar type is not being pickedup correctly by the employe type but by the manager type.

       

      In this case I have made the following chages to your code:

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

       

      Has you can see the change on the code is the fact that instead of using the MAX directly to get the CalType i'm making a Calculation of the CalType but restricted by the enmploye name (ALLSELECTED part) this allows to get for that specific person the calendar type. 

       

       

      • jac88's avatar
        jac88
        Helper II
        4 years ago

        Hi MFelix 

         

        Thank you so much for the resolution. I hope you had a great weekend as well. This is good but the only issue is "iMetaWeekend" Friday and Saturday only work for April. Do you happen to know why is that? 

         

        Thank you so much