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.
Jolly Day,
I currently have my visual set to just give me year 2021. I am wanting it to automatically update go two years back so I need it set to year 2022 when we begin year 2024. Is there a way to accomplish this? I created a year column that just parsed the year from my date so we also have the full date to work with. Any help with this would be greatly appreciated!
Thanks in advance,
Idon'tquitegotthepowerBI
Solved! Go to Solution.
try to do this
1 create a new measure
Filter_DateTable_Year=IF(MAX(DateTable[Year])=YEAR(TODAY())-2,1,0)
2 add this measure to page filter, and filter the values equal to 1
try to do this
1 create a new measure
Filter_DateTable_Year=IF(MAX(DateTable[Year])=YEAR(TODAY())-2,1,0)
2 add this measure to page filter, and filter the values equal to 1
Thank you so much! Do you think you could break down how this is working?
it's like adding a column in the Date Table
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |