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.
Hello,
I need to multiply each value in a column by a value that can be altered. I have checked this post here
http://community.powerbi.com/t5/Desktop/Multiply-column-values-by-a-number-which-can-be-altered-on-t...
But I guess the purpose in that post was to multiply one single value by another number, not each single value in a column, because when I tried to apply the measure it told me that it can not be applied on multiple values.
Am I missing something?
Thanks in advance
Solved! Go to Solution.
@jubrna01,
You can create a measure using similar DAX below.
Measure = MAX('Yourtable'[yourcolumn] )* MAX([alteredColumn])
Also you can take use of what if parameter in Power BI Desktop.
If you still get errors, please share sample data of your table and post your dax here.
Regards,
Lydia
In case some one have the same problem, this is the final solution
Total Adj Sales ALT 2 = SUMX ( 'Table', SWITCH ( TRUE (), 'Table'[Adjustment] = "b", 'Table'[Sales] * what_if_parameter, 'Table'[Adjustment] = "c", 'Table'[sales] * what_if_parameter, 'Table'[Sales] ) )
@jubrna01,
You can create a measure using similar DAX below.
Measure = MAX('Yourtable'[yourcolumn] )* MAX([alteredColumn])
Also you can take use of what if parameter in Power BI Desktop.
If you still get errors, please share sample data of your table and post your dax here.
Regards,
Lydia
In case some one have the same problem, this is the final solution
Total Adj Sales ALT 2 = SUMX ( 'Table', SWITCH ( TRUE (), 'Table'[Adjustment] = "b", 'Table'[Sales] * what_if_parameter, 'Table'[Adjustment] = "c", 'Table'[sales] * what_if_parameter, 'Table'[Sales] ) )
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |