Forum Discussion

cyber_sinh's avatar
cyber_sinh
New Member
9 years ago
Solved

Bug in the top N function?

Hi,   I'm trying to show only the last 5 last years of data (2013-2017). So, I used the TOP N feature to filter unwanted years but if I set 5 in top N feature, the year 2012 is not filtered and the...
Reports
  • cyber_sinh's avatar
    cyber_sinh
    9 years ago

    Hi,

     

    To solve the issue, I used the date column (and not the year) of the same ref_dates table (using the date column of the 'fact' table didn't work), filtered with the new relative date (last 5 years) and the missing data were appeared as expected.

     

    I still don't understand why filtering directly with the year colum has a such unpredictable behavior.

     

    Thanks for your help.

     

    Regards,

     

    Cyber Sinh

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

cyber_sinh

 

Please use the Year column of Fact table instead of the Year column in Calendar (ref_dates) table. Please refer to following screeenshot.

 

 

Best Regards,
Herbert