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 a simple IF statement that works to display an image URL when conditions are met, but I'd like it to evaluate only in the context of THIS calendar month. At the moment it either rolls up the result for all months in my table or I can get it to display direcrly in a table with each month represented.
It will let me have a second filter but it's not working.
Any ideas?
Hi @Faye1901,
Here I made a test by creating a caluclate column.
Column = IF(Table2[Difference red]=0,MAX(Table1[Column1]),MIN(Table1[Column1]))
Then change the column to Web URL.
Regards,
Frank
Thanks for this. I've realised that a calculated column is the answer for sure - so I'm back to the drawing board.
I've now:
1. Created a summary table (so I don't need all those measures) using:
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |