The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I have a tablet that show the balance sheet of a company, where revenue and expenses are shown, to calculate profit or loss.
The client needs this specific requirments of having all the expenses shown as numbers between brackets (###,###.##)
Any idea how I can achieve this.
I tried having a calculating column where I can enter the type of the item in the balance sheet (expense or revenue).
But I am stuck of having the conditional formatting works as a condition of different column.
Please help
Solved! Go to Solution.
Hi @matout
Try this measure:
Expences between brackets =
FORMAT ( MAX ( 'Table'[expenses ] ), "($#,##0)" )
Output:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your Kudos !!
Hi @matout
Try this measure:
Expences between brackets =
FORMAT ( MAX ( 'Table'[expenses ] ), "($#,##0)" )
Output:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your Kudos !!