selecting a specific measure based on date

[LucasFranz]

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.

[v-easonf-msft · Accepted 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