Forum Discussion
Helper IYoY not showing values
YoY not showing the data. It is a very simple file yet I am unable to get the desired output 😞
6 Replies
PadycosmosSolution Sage
Hope this helps:
hemamaleniPlease 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
- hemamaleni
If I change the Value from 0 to -1, it doesn't show any data.
- 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.
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 _ PollyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
