If Holiday

[RobRayborn]

I have a Measure that of Sum(UnitSales, [Sales Amount]). I also have a Date table with a IsHoliday Column is True or False.
The UnitSales Table will show 0 on days that nothing was sold, and Weekends also show as 0.  
I have a Table Visual with the Date in the first column and the Sum(UnitSales, [Sales Amount]) in the second column.

I need a DAX measure that will show if the Date is a Holiday (True) then "Holiday", else the Sum(UnitSales, [Sales Amount]).

It seems pretty straight forward until start writing the DAX measure out.

[ChiragGarg2512 · Accepted solution]

@RobRayborn , create a measure using if statement,

DayStatus = if(selectedvalue(isHoliday) = True(), "Holiday", Sum(UnitSales, [Sales Amount]))

This should help, Thank You.