I am trying to create a report that will look at sales based on two dates that can be entered by the user. Get total sales for 1 time period, then total sales for second time period so a retaliative value can be created and sorted by. I am trying to create a measure that is hard coded to the date 1 filter then editing interactions so that the date 1 filter wont actually filter anything (except the measure) but I am not having any luck. I am pretty new to Power Bi so I am not even sure if this is the right approach. Below is an example of what I am trying to create.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Total Orders After Date 1[/TD]
[TD]Total Orders After Date 2[/TD]
[TD]% of sales[/TD]
[TD]Difference[/TD]
[/TR]
[TR]
[TD]Cust 1[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 1,000,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] 150,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]15%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]-850,000[/TD]
[/TR]
[TR]
[TD]Cust 2[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 1,200,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] 850,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]71%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]-350,000[/TD]
[/TR]
[TR]
[TD]Cust 3[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 800,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] 475,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]59%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]-325,000[/TD]
[/TR]
[TR]
[TD]Cust 4[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 900,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] - [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]0%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]-900,000[/TD]
[/TR]
[TR]
[TD]Cust 5[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 200,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] 200,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]100%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
Any suggestions are greatly appreciated.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Total Orders After Date 1[/TD]
[TD]Total Orders After Date 2[/TD]
[TD]% of sales[/TD]
[TD]Difference[/TD]
[/TR]
[TR]
[TD]Cust 1[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 1,000,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] 150,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]15%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]-850,000[/TD]
[/TR]
[TR]
[TD]Cust 2[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 1,200,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] 850,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]71%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]-350,000[/TD]
[/TR]
[TR]
[TD]Cust 3[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 800,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] 475,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]59%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]-325,000[/TD]
[/TR]
[TR]
[TD]Cust 4[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 900,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] - [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]0%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]-900,000[/TD]
[/TR]
[TR]
[TD]Cust 5[/TD]
[TD][TABLE="width: 168"]
<tbody>[TR]
[TD="class: xl65, width: 168"] 200,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD="class: xl65, width: 171"] 200,000.00 [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 69"]
<tbody>[TR]
[TD="class: xl65, width: 69, align: right"]100%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
Any suggestions are greatly appreciated.