2 measures in one by date

Hi jnrezk ,

How many data table do you have?

Here are two scenarios:

1. You have two data tables, one for measure before 2021/12/17, another one for measure after 2021/12/17.

2. You have only one data table, it contains all values and you create two measures based on it.

Here I suggest you to create a calendar table with continuous dates by dax. Then relate it with your data table by Date columns. Then create a measure and build a visual by Date column from calendar table.

I think the odds are that you are in situation 1.

Measure = 
IF(MAX('Date'[Date])< DATE(2021,12,17),[Before 2021/12/17],[After 2021/12/17])

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.