My LYTD expression working fine But YTD not working ?

[admin11]

Hi All

I have below expression working fine , able to return correct value  :-

Switch_LYTD REV&COGS = SWITCH(SELECTEDVALUE('_PNL_Table'[REV&COGS]),

"COGS",[_LYTD COGS],

"REV", [_LYTD REV],

"OTH", [_LYTD OTH],

"EXP", [_LYTD EXP]

)

When i convert the above expression to YTD , it return null :-

Switch_YTD REV&COGS = SWITCH(SELECTEDVALUE('_PNL_Table'[REV&COGS]),

"COGS",[_YTD COGS],

"REV", [_YTD REV],

"OTH", [_YTD OTH],

"EXP", [_YTD EXP]

)

Paul Yeo

[amitchandak · Accepted solution]

@admin11 , This because where is data , I clicked on 2019 and I can see YTD data.

Data is for 2018 and 2019 only. you page is just showing data on for 2019

[admin11]

@amitchandak 

Thank you , you are correct.

Paul

[admin11]

Hi All

My PBI file :-

https://www.dropbox.com/s/u3wohf9n45qebcr/GL_ISDN_v007%20Only%20PMC%20only%201000%20row.pbix?dl=0

Paul