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!
I am making a raport which analyses the progress of the MSCI index of a list of countries. I would like to have a graph with the MTD of the countries which perform worst at a certain date. The dates in the dataframe are non consecutive. For example, to show a graph consising just the top five worst perfoming countries by the end of august, i used this DAX.
MTD end aug count DM =
VAR aug = CALCULATE (
MAX ( 'Country DM'[Date] ),
FILTER (
'Country DM',
'Country DM'[Date] <= DATE(2021,8,31)
)
)
RETURN
CALCULATE(SUM('Country DM'[MTD]), 'Country DM'[Date] = aug)
MTD end month count DM =
VAR month = CALCULATE (
MAX ( 'Country DM'[Date] ),
FILTER (
'Country DM',
'Country DM'[Date] <= SELECTEDVALUE('Country DM'[Date])
)
)
RETURN
CALCULATE(SUM('Country DM'[MTD]), 'Country DM'[Date] = month)
@KarianneKies Hi, though I am not 100% sure before see your report, I guess (from your explanation) that you put the [date] as outer fitrer so that user can select specific date. in that case, power BI can see only data for the selected date (1 day) among whole table.
Please mark it as soluntion if helped.
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |