Comparison between two ranges in a table stored in one database - URGENT!

[Anonymous]

Hello everyone! Im Daniel, Talking from Brazil.

I'm having a massive trouble in Power Bi, and I realy dont know where Im going wrong.

I have one table in SQL that stores the "photos" of the database every begining of month. 

The idea is to have the possibility to analyse on the expected amount for the month, in DAX, the ones that I won, the ones that I Lost, the ones that I rearrenged the expectation and the ones that I havent done any actions about the expected closing.

For example. I have a foto of Feb/20 and another in Mar/20.
The colum "Photo Date" when equals to "Feb/20" show me all projects in Feb20. And when I compare it to Mar/20 I see what happened along the month with these projects.

I want, when the user select "Feb/20" the comparison goes automaticaly to "Mar/20"
They are sotred in the same database.

Witch Options do you think that is the best for comparison? I've been trying to do this for a long time and I'm not being successful.

.Base Sample

Regards!

Daniel.

[Stachu · Accepted solution]

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5

For example. I have a foto of Feb/20 and another in Mar/20.
The column "Photo Date" when equals to "Feb/20" show me all projects in Feb20. And when I compare it to Mar/20 I see what happened along the month with these projects.

I want, when the user select "Feb/20" the comparison goes automatically to "Mar/20"

 you could create a measure for current month, and another one for the next month, using e.g. DATEADD in the CALCULATE

https://docs.microsoft.com/en-us/dax/dateadd-function-dax

to be more specific I would need a copyable version of your data