Forum Discussion
Problem to Use DATEADD with a Limited Filter
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?
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.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.
3 Replies
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.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.
Worked with a Calendar Table!