There is something incredible about EXCEPT function which may pass unnoticed. It's got an implicit TREATAS function. This works: EXCEPT( VALUES( 'Date'[DayOfWeek]), SmallTable) ), as long as the SmallTable is a single column table with WHATEVER column name!
There is something incredible about EXCEPT function which may pass unnoticed. It's got an implicit TREATAS function. This works: EXCEPT( VALUES( 'Date'[DayOfWeek]), SmallTable) ), as long as the SmallTable is a single column table with WHATEVER column name!
Thank you 👍
thank you
Hi Alberto, thank you! What might be a possible way to return entire Date table (all columns) but excluding the weekends? Something you try 2:28.
Is there a reason you would use Except rather than Filter?