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.
MY requirement I have to take some specific category and that also till this month (Actual Unit) from the given sample table.
because I have data from 2017 to 2023.
EX:- I have to take 2017 to Current month with only A and B category(Actual Unit)
Solved! Go to Solution.
Hi @ukantkumar ,
You could add below measure into "Visual level filter" ad set its value to 1.
check = IF ( YEAR ( SELECTEDVALUE ( Test_5[DATE] ) ) <= YEAR ( TODAY () ) && MONTH ( SELECTEDVALUE ( Test_5[DATE] ) ) <= MONTH ( TODAY () ) && SELECTEDVALUE ( Test_5[category] ) IN { "A", "B" }, 1, 0 )
Best regards,
Yuliana Gu
Hi @ukantkumar ,
You could add below measure into "Visual level filter" ad set its value to 1.
check = IF ( YEAR ( SELECTEDVALUE ( Test_5[DATE] ) ) <= YEAR ( TODAY () ) && MONTH ( SELECTEDVALUE ( Test_5[DATE] ) ) <= MONTH ( TODAY () ) && SELECTEDVALUE ( Test_5[category] ) IN { "A", "B" }, 1, 0 )
Best regards,
Yuliana Gu
Hey,
can you please prepare some sample data in an Excel file, upload the file to onedrive or dropbox and share the link.
Please, provide an example what the expected result should look like.
Regards,
Tom
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |