Switching Measures Depending on Selected Dates

[Gutierrez]

Hello guys, hope you are doing well. 

I had a call log table for one system, then we moved (on 11/1) to another system hence we have another call log table. I have a requirement to merge both data so they can view the right numbers depending on the date they select.

My problem is that when I select data before 11/1/23 (even mulltiple values) the new measure that I've created works, but when I select multiple values (in this case only 11/1/23 and 11/2/23) is not aggregation the values, it only works if I select a single date.

I'll post a few pictures and below the information:


(this is the view before 11/1/23, you can see that the "Combined AHT" shows the total when I select more than one day)



This is after 11/1/23 but only selecting 1 value. The "Combined AHT" total works the same way as the "New AHT" (this one is only taking data on or after 11/1/23).



And here is when I select multiple values after 11/1/23. You can see that the aggregation is not working (it should be 472).




Lastly, here is the measure I'm using for the "Combined" view.

If you please can help me out with this, I'd appreciate it a lot.

Thanks!

[parry2k]

@Gutierrez all well if it ends well. Cheers!

[Gutierrez]

Quick question.. this works if I select either dates before the changes or after the changes, but if I select all 2023 for example, it will sum both numbers (before november and after) and reflect an inflated value (am I explaining myself?). 

[parry2k · Accepted solution]

@Gutierrez if there is a clean cut between old and new data then why not simply create a new measure which is sum of OLD AHT + NEW AHT

Combined AHT = [OLD AHT] + [NEW AHT]

[Gutierrez]

Oh gosh, I guess I responded myself saying that it's not gonna be populated anymore (the old table). 
Thank you sow much, I assume this would perfectly work for the other metrics.
Always a pleasure search on this page for any help!
Sometimes we try to make it harder than it really is!

[parry2k]

@Gutierrez total issue is a common scenario, it is not a bug but needs further attention to make it work. 

My first question is, why don't you append both these tables together in the Power Query, and then you don't have to do any workaround to use multiple measures?

[Gutierrez]

Hey! thanks for your response.
Since it's a new system, the tables don't have the same structure, the old data won't be used again (or populated) but it's still historical data that needs to be shown