Problem to Use DATEADD with a Limited Filter

[alexandrestaffa]

i am trying to calculate return on investment based on a positon that the initial balance is the last balance from the previous month.
I created a measure to bring the last month balance, but when a filter the year 2022, january is left blank!! Thus, when I use a graph by year, the 2022, 2021 are wrong because january is never there!
any form to solve it?

[v-kkf-msft · Accepted solution]

Hi @alexandrestaffa ,

Based on my testing, if the row fields of your matrix and the fields in the slicer are from the Calendar table, then the January measure is not blank when you select a specific year. So in your report they come from the same table 'Aplicações Financeiras'?

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-kkf-msft · Accepted solution]

Hi @alexandrestaffa ,

Based on my testing, if the row fields of your matrix and the fields in the slicer are from the Calendar table, then the January measure is not blank when you select a specific year. So in your report they come from the same table 'Aplicações Financeiras'?

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alexandrestaffa]

Worked with a Calendar Table!

[alexandrestaffa · Accepted solution]

Yes, the date  come from Aplicacoes Financeiras, I dont use a Calendar table in this case, I will try to do with a calendar table to check if solves.