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 all,
i have following measure
Solved! Go to Solution.
Make sure the [year] column dragged to table visual comes from another table that has no relationship with the slicer.
Make sure the [year] column dragged to table visual comes from another table that has no relationship with the slicer.
Because it is a dynamic measure. You should try this:
test = IF ( HASONEVALUE(calender[year]); VALUES(TODAY(calender[year])-5 )
or this
test = IF ( HASONEVALUE(calender[year]); VALUES(TODAY()-5 )
or this
test = IF ( HASONEVALUE(calender[year]); VALUES(YEAR(TODAY())-5 )
I dont remember the proper way, but the idea is to use today's year instead of the five years less than the selected value.
TODAY dont work
Try using Max(Year), Max(Month), Max(Day) or something like that
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 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |