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 everyone,
I want to select a date from a slicer and then my measure should only deliver the selected and the 2 next month:
So if I select 2011-08 on my slicer:
Then I want in all tables just to show the selected month and the following 2 month:
Somehow I'm a little stuck.
I can get the highest selected date with:
max(DimDate[FullDateAlternateKey])
SumSales+3 = VAR maxDate = max(DimDate[FullDateAlternateKey]) RETURN CALCULATE(SUM(FactInternetSales[SalesAmount]); FILTER(DimDate;DimDate[FullDateAlternateKey]>=maxDate && DimDate[FullDateAlternateKey]<DATEADD(DimDate[FullDateAlternateKey];3;MONTH)))
Hi @selimovd ,
For your requirement, you could refer to this similar thread firstly.
If you still need help, please share your data sample so that we could help further on it.
In addition, here is another reference.
Best Regards,
Cherry
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |