Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have created the below table using two measures.
Billing Price = SUM ( 'Project Hours Booked'[Cost]) * MAX('Fee Factor'[Fee Factor])
Billing Price (cumulative) =
CALCULATE(
SUM ( 'Project Hours Booked'[Cost]) * MAX('Fee Factor'[Fee Factor]),
FILTER(
ALLSELECTED('Project Hours Booked'[WeekNo]),
ISONORAFTER('Project Hours Booked'[WeekNo], MAX('Project Hours Booked'[WeekNo]), DESC)
)
)
'Project Hours Booked'[Cost] is a currency (i.e. £).
'Fee Factor'[Fee Factor] is the mark up on the cost and is a decimal number.
As you can see, both columns are returning values without a currency. Any suggestions on how I correct this? I first thought about making 'Fee Factor'[Fee Factor] a currency but I use this in a slicer so don't want to misrepresent the units.
Thanks in advance.
Dan
Solved! Go to Solution.
Select each measure. On the Modeling ribbon, Formatting tab, select the appropriate currency type from Format|Currency.
Select each measure. On the Modeling ribbon, Formatting tab, select the appropriate currency type from Format|Currency.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |