If Holiday

RobRayborn — Wed, 27 Sep 2023 13:34:07 GMT

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.

Re: If Holiday

ChiragGarg2512 — Thu, 28 Sep 2023 07:05:26 GMT

RobRayborn , create a measure using if statement,

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

This should help, Thank You.

topic Re: If Holiday in DAX Commands and Tips

If Holiday

Re: If Holiday