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.
<tbody>
</tbody>
Any suggestions are greatly appreciated.
Customer | Total Orders After Date 1 | Total Orders After Date 2 | % of sales | Difference | |||
Cust 1 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | -850,000 | |||
Cust 2 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | -350,000 | |||
Cust 3 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | -325,000 | |||
Cust 4 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | -900,000 | |||
Cust 5 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 0 |
<tbody>
</tbody>
Any suggestions are greatly appreciated.