How to clear error on P&L Annual Amount expression ?

[admin11]

@VijayP 

Below is PBI file for P&L statement create by you working fine , you able to compute annual total :-

https://www.dropbox.com/s/hje6v9ay7129rg0/P%26L%20%281%29.pbix?dl=0

I try to create the P&L base on VijayP above PBI file , i follow step by step . i get error :-

The expression specified in the query is not a valid table expression.

Below is my PBI file :-

https://www.dropbox.com/s/d9lm069wxf3ds8k/PBT%20GL%20VER0066.pbix?dl=0

Hope some one can help me.

Paul Yeo

[VijayP · Accepted solution]

@admin11 

Please find attached revised

[admin11]

I just want this post go to the top , so that i can work on it. case already closed,

[admin11]

@VijayP 

I have add the rest of mesaure , i still get null when apply Annual Total on Table .

https://www.dropbox.com/s/v1db7lnl43229ns/PBT%20GL%20VER0067.pbix?dl=0

Paul