How to show the hitrate per month per store

[Lila05]

Hi,

I would like so show the trend of the hitrate per month in a store. My table looks like the one below and I would like to create a graph with year-month (2301, 2302 etc.) on the x-axis, number of created respectively signed offers on the y-axis1 and the hitrate (signed/created) on the y-axis2. Every time I put in both created and signed in my graph I get an error, which I kind of understands but I have also tried to create relationship with a seperate date-table but I can´t get to work either.. 

Store	Offer	Created date	Signed date
a	1	2023-01-01	2023-01-15
b	1	2023-01-08	2023-02-06
b	2	2023-01-15	2023-01-20
a	2	2023-01-01	2023-02-03
c	1	2023-01-10	-
a	3	2023-01-12	2023-01-20

Thanks in advance!

[v-yueyunzh-msft]

Hi , @Lila05 

Thanks for you sample data ,according to your description, you want to show the  hitrate per month per store.

And it seems to use the both [Created date] and the [Signed Date] in the table.

So i think you need to create a date table as a dimension,and you do not need to create any relationship between tables. And you can create a measure to realize your need . For your description, i an not fully understand the end result you need in your logic judgement.

If this method does not meet your needs, you can provide us with yourdesired output sample data in the form of tables and describe the detail logic , so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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