How would you amend the current DAX Measure to add percenatge value based on External Sale into the Measure - So the Column show both the data and percentage values as shown in the excel file attached.
Go to Solution.
In Power BI, one column will have only one column type.
If you want to show (%) percentage type and (£)fixed decimal number type in the same column, you can build a calculated column or measure in text type.
For more details about mixed data type column: columns with mixed data types
Your Excel and Sample PBIX have beem deleted Currently.
If this reply still couldn't help you solve your problem, please share the sample with me agian by your Onedrive for Business.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@Route217 , refer if these two can help
Proud to be a Super User!
This article outline how to format the data points i need to calculate the % values and add them into the current DAX Measure - which i cannot do??
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.