Forum Discussion
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...
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
Hello,
Thank you so much for your response, this is kinda working. I want to show the Weekend regardless of the blank. If there is an event or not it should show up. So I remove the blank part of your formula did not work.https://drive.google.com/file/d/1tM6gCCZlvoZou2fCs-l8jwG9SDQkRLuF/view?usp=sharing
Thank you so much for your time and help.
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.
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
