I’m following the structured learning course on Financial Reporting w/ Power BI. I’m on the lesson with Using SWITCH/TRUE logic for template design.
Everything has been going great, until I tried to put the format function around a Divide function so that a calculation would be formatted as a percent.
I’m in Excel Power Pivot and suddenly the pivot table added extra columns. I have no idea why.
Here it is without the Format function
Here it is with the Format function