DAX – The Diabolical Genius of “SWITCH TRUE”
SWITCH() is still testing for equivalence! By providing the first argument as TRUE(), now each subsequent “test” will check for TRUE().
SWITCH() is still testing for equivalence! By providing the first argument as TRUE(), now each subsequent “test” will check for TRUE().
In This Case, Getting the Grand Total Correct for Each Row Required SUMX It’s that time of year again… …when my love of spreadsheets actually translates into a love of […]