Question: SWITCH ( ) with TRUE ( ) The TRUE ( ) function can be used as the first argument in the SWITCH ( ) function.
SWITCH with TRUE
The TRUE function can be used as the first argument in the SWITCH function. In this case, SWITCH searches for the first value that is true.
Why did we use this method in the case study?
To maintain the sort order of the line items from the custom headers table
To return different DAX measures for different financial statement line items based on the MeasureName column
To add custom line items to the financial statements
There was a transaction for every GL so each transaction should return TRUE
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
