Thanks a lot for your answer. I am sorry for inconvenience regarding the forum rules. Next time I will be careful.
First of all I watched Financial reporting module. So that’s why I was able to model income statement and the balance sheet successfully. It is woking fine. It’s a great course.
Because it is live connection to the SSAS, therefore I can not copy my original file. However, I made exact same copy with Sam’s file that he covers during the module. In this file all I did was to modify the Selected year actuals measure for YTD and then the corresponding measures accordingly. I modified Revenues, COGS, profits etc. all the related referenced measures in the selected year actuals meausure.
All I am trying is in a matrix table I want to be able see the income statement items on the rows and months on the columns. And I want to be able to see results cumulatively starting from january to december.
In the demo file that I am attaching there are Two sheets. One with YTD and the other is normal one. The one with YTD is showing montthy results although I modified each measure for YTD. I guess once I put the months onto the columns it is filtering each month individually. I tried ALL, and ALLSELECTED to change context however it is not working as well.
so I appreciate for your replys.
all the bestFinancial Reporting In Power BI - Kopya.pbix (894.1 KB)