Forum Discussion
Matrix with several colulmans
Dear:
I was able to solve the problem, I leave the solutions in case anyone needs it in the future.
In the original measure the last filter of the Calculate is the lastday of the table where I have the transactions. That date field is attached to the data model calendar.
So instead of filtering the date in the data table, it made any segmentation do the calculations within and each segmentation. To have the last day of the total I changed the lastday with the calendar date (this has no union with the attribute tables) so I did the calculation well.
Please consider it resolved!
Thank you, Greetings.
Dear:
I was able to solve the problem, I leave the solutions in case anyone needs it in the future.
In the original measure the last filter of the Calculate is the lastday of the table where I have the transactions. That date field is attached to the data model calendar.
So instead of filtering the date in the data table, it made any segmentation do the calculations within and each segmentation. To have the last day of the total I changed the lastday with the calendar date (this has no union with the attribute tables) so I did the calculation well.
Please consider it resolved!
Thank you, Greetings.
Petazo , Thanks for sharing the solutions. Kudo's to you.
