Mark on 28 Nov 2019 00:47:02
The scalability for some expression in Excel are way more dynamic than DAX's Version.
For example, DAX's 'OR' statement can only handle 2 criteria, whereas excel can handle much more.
Similarly, excel has the 'IFS' statement, which work sort of like 'SWITCH' however, it can handle text as well.