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,
This is OK, is exactly what I need, Im only appliying one relative filter for the last 1 year
But the problem is when I want to se only 2020, indicating that in a slicer:
it shows me only two month, because of the relative date filter, how can I see the entire 2020 year?
Solved! Go to Solution.
@tsynenkyy , relative date slicer work from today. You have to create one of you own with independent date slicer
refer
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
and for last year
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
@tsynenkyy , relative date slicer work from today. You have to create one of you own with independent date slicer
refer
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
and for last year
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))
Hi,
Thank you again for your help 🙂
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |