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 Experts
How would yo do the following on a matrix table in Power BI (the expected end result is in the sample excel file)
I want to be abloe to subtract the value to the left start point 2nd column in - Hence (2949 - 2083) =-866 and so on
Data
Sample data with expected end result.
Link: https://www.dropbox.com/scl/fi/x6sm7wt07b94v7umt727v/Book1.xlsx?dl=0&rlkey=50w1tpy8qcp8zyd8zpl0vpusg
Solved! Go to Solution.
Hi @Anonymous ,
I do not know exactly your fields (PDate and Date).
But what you need is sth like this:
[YourMeasure]
- CALCULATE (
[YourMeasure],
FILTER (
ALL ( 'DateTable' ),
'DateTable'[Date]
= MAX ( 'DateTable'[Date] ) - 1
)
)
If this answer solves your problem, give it a thumbs up and accept it as a solution so the others would find what they need easier.
Regards,
Loran
Hi @Anonymous ,
I do not know exactly your fields (PDate and Date).
But what you need is sth like this:
[YourMeasure]
- CALCULATE (
[YourMeasure],
FILTER (
ALL ( 'DateTable' ),
'DateTable'[Date]
= MAX ( 'DateTable'[Date] ) - 1
)
)
If this answer solves your problem, give it a thumbs up and accept it as a solution so the others would find what they need easier.
Regards,
Loran
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |