Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Financial Report

Hello,   I'm trying to build a financial report that looks like the picture. Until now I have managed to, build the 17 columns that have to do with the current year 2020. (months,quarters and 12-mo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Update! Here are the tables and relations that I created

 

 

Unfortunately, I expected that the columns that contain the 2020 data would be filled in but the whole report is empty.

 

 

Any idea? Thanks!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Update Vol2

 

Rookie mistake, I had to turn into "Text" the date 'mmm yyyy' column

 

 

I will come back here if I have new questions about the measures! Thanks a lot!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello MattAllington 

     

    I tried to do a measure but didn't workout, is there a way to caclulate let's say the column "Q1 2019 Total"?

     

    The idea is that I want a sum of same account numbers WHERE Quarter = 1, and the same logic I think goes to the other columns, too, what is the DAX strategy/measure that I should follow?