Measure to compare values for each day

[Anonymous]

Hi everyone,

I hope you're fine. I need your help with a measure that I want to use on one of my reports.

Context : We organize every year an operation that allows our customers to subscribe for cashback, in 2019 it started on the 4th October and continued until the 31st December. This year the operation started on the 10th October and will probably continue until the 31 December. So I need to compare the sum of the subscriptions for each day (1,2,3 etc...) in 2019 and 2020.

Here you can see my tables, the subscriptions are in this table which is daily updated from our data lake :

Then, I created 2 additional tables in which I attributed a day number for each date (2019 and 2020) :

The relations :

Is there anyway to automate this comparison ?

Best regards, 

Othman

[v-robertq-msft]

Hi, @Anonymous 

According to your description, I can understand what you want but I find it difficult to create the sample data.

Would you like to post some sample data(just the tables this case involved with without sensitive data) and your expected result? So that we can help you in advance.

Thanks very much!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[luxpbi]

Hi @Anonymous,

I hope you are fine as well.

Have you considered to use DATESBETWEEN()?  

If you need more help, you can provide sample data and I can try to deply the solution in your model. 

Regards,