YoY not showing values

[hemamaleni]

YoY not showing the data. It is a very simple file yet I am unable to get the desired output 😞

[v-rongtiep-msft]

Hi @hemamaleni ,

Please have a try.

Create a measure.

Measure = CALCULATE(SUM(Table_A[amount]),FILTER(ALL(Table_D),Table_D[year]=SELECTEDVALUE(Table_D[year])-1))

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hemamaleni]

I was able to do it after I set my calendar table to 'mark as date table' under 'table tools' options. But in my real project I have production year and calendar year. I need to use production year which offsets the amount a little, since the 12/31/2022 would be considered as production year 2023 instead of 2022.

[hemamaleni]

If I change the Value from 0 to -1, it doesn't show any data. 

[Padycosmos]

Hope this helps:

[hemamaleni]

Please check and let me what I am doing wrong. D table is Calendar. Should I use that or A table which is fact.

[Padycosmos]

It appears that there is no built-in date calendar for the c-date column from where you have to select c_date.[date]. To enable a built in Date calendar, you can do the following

File >> Options & Settings>> Options >> Global >> DataLoad>>  Tick the box below Time Intelligence