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.
So, I have a list of costs that are updated once a month and I need to be able to present the latest value. As you can see in the attached image, I have 2 "groups". The first one should present only the most recent costs values and the other one should present all off the costs values through the different dates. How can I show only the most recent values in the first group and all of the values in the seconde one?
THANKS!
Solved! Go to Solution.
Hey @Anonymous ,
you should be able to solve that with the pattern for semi additive measures. An easy example would be:
Balance LastDate :=
CALCULATE (
SUM ( Balances[Balance] ),
LASTDATE ( 'Date'[Date] )
)
But check out the full article to get all the details about the semi additive measures:
Semi-additive calculations – DAX Patterns
Hey @Anonymous ,
you should be able to solve that with the pattern for semi additive measures. An easy example would be:
Balance LastDate :=
CALCULATE (
SUM ( Balances[Balance] ),
LASTDATE ( 'Date'[Date] )
)
But check out the full article to get all the details about the semi additive measures:
Semi-additive calculations – DAX Patterns
I think it works, but I have to create a measure for all the different costs right?
Best Regards
Hey @Anonymous ,
for everything that is semi-additive you need to create an own measure.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |