Forum Discussion
dchakarova
3 years agoNew Member
Date problem
I have two measures in two different tables. In both tables i have a month and year columns. When i put my measures in a visual (a tale for now) and use the month from one of the tables it gives the ...
mangaus1111
3 years agoSolution Sage
Hi dchakarova ,
if you want to filter the sum for the month of January for example, you have to use the below measure
RT = CALCULATE(SUM('2019-2022'[sumrt]),'2019-2022'[mes] = "January").
Do you have sample data of your tables in text format?
- dchakarova3 years agoNew Member
I want to show the movement of the two measures for all months from january untill october. It will be a bit difficult to make a sample data base right now.
- dchakarova3 years agoNew Member
I connected the two bases not to the calendar, but to the dates in each one, but it still showes the same data.