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 have matrix in PowerBi of portfolio values.. In the data there is a column for 'moves', 'groupcoa' and the values are GBP.
I just want a subset of this data for Capitalised Interest such that I only bring back the GBP values where moves = ICAPI or ICPIK ans the account is in 1301,1351,1361,1401,1461. In Qlikview i would have put this in an expression as below in the matrix
sum({<moves = {"ICAPI", "ICPIK"}, groupcoa = {"1301","1351","1361","1401","1461"}> }GBP)
In powerbi, how would you do this? Would you add a column into the data query or create a measure or do you have to hardcode the filters? Many thanks Paul
Solved! Go to Solution.
You can apply these filters using the filter pane of the visual or you can create a measure to calculate this.
You can apply these filters using the filter pane of the visual or you can create a measure to calculate this.
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.