Forum Discussion
YTD expression return null value
Hi All I Have below expression work fine , it return correct amount :- SUM_YTD = SUMX('_PNL_Table','_PNL_Table'[Switch_YTD]). But below expression display Null :- Switch_Y...
Hi All
Below is my PBI sample file
Paul
hi admin11 - The measure will calculate based on a particular value of GL type (COGS, EXP, OTH, REV) - hence you will have to add a slicer into your report for the same. Please see screenshot below for reference.
Attached is the updated pbix file.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue.
Thanks!
Sumanth
Anonymous
When i click Step 2 , it select year = 2020 , Table 2 YTD expression display value is correct.When i click Step 1 , it select year = 2019 , Table 2 YTD expression display null. But Table 1 display there are value.
Below is my PBI file :-
https://www.dropbox.com/s/22lziixb1kx8nf2/APPEND%202%20GL%20INTO%201%20V006.pbix?dl=0
Paul Yeo