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.
hey everyone, this is my first post here and I hope a can contribute the same way this community is helping me.
so I have 2 measures, which compile financial data (from the same "groups"), but one is BUDGET for now on, and the second one is DONE (each one comes from a different table).
I really want to use something like an measure with IF statement to condense both measures in the same timeline.
e.g.: for dates < 11/1, DONE; for dates > 11/1, BUDGET
so I need to have GREEN (DONE) columns until october, and BLUE (BUDGET) columns in november and december, without all these blank columns, and only BLUE (BUDGET) in november.
Solved! Go to Solution.
Hi, @LucasFranz
You can try formula as below:
Measure = IF(SELECTEDVALUE('Table'[Date])<DATE(2021,11,1),'Table'[Done],'Table'[Budget])
If it doesn't work, please share your sample file.
Best Regards,
Community Support Team _ Eason
Hi, @LucasFranz
You can try formula as below:
Measure = IF(SELECTEDVALUE('Table'[Date])<DATE(2021,11,1),'Table'[Done],'Table'[Budget])
If it doesn't work, please share your sample file.
Best Regards,
Community Support Team _ Eason
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |