Hi all, first of all i’m a beginner user of power BI, i’m studing beginner course and now i’m following the webinar related the Financial Report.
Monthly, i prepare for CEO a financial report and i’m trying to convert my excel report into a Power Bi dashboard report.
I have a question related balance sheet, particularly it’s clear to obtain the actual value but i’m not able to compare the data with previous year, i explain better in my report i compare the current month with final data of previous year (for example oct 2020 compare with december 2019, nov 2020 with dec 2019, etc…), how i can solve that problem, it’s possible?
it’s clear in the income statement case, infact i’m able to compare oct 2020 with october 2019, etc… with daxformula samelastperiod, but i can’t solve the problem in balance sheet where i need to compare with the final data of previous year.
I need only some suggestion, at moment i’haven’t build my report but i’m trying to build the project in my mind.
thanks very much