Forum Discussion

EpicTriffid's avatar
EpicTriffid
Helper IV
6 years ago

Last three from a specific year

Hi all,   I have a column that identifies whether a year is our most recent year for a specific KPI. Some of our KPIs have been released this year, but some others havent been updated since 2017. S...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi EpicTriffid ,

Maybe you can take a look at the following blog about using date function to manually defined filter condition and filter range to achieve rolling calculation.

Time Intelligence "The Hard Way" (TITHW)  

In addition, are there any specific filters that existed in your calculation formula? (e.g all, allexpect...) They can also affect the calculation results.

Regards,

Xiaoxin Sheng

EpicTriffid's avatar
EpicTriffid
Helper IV
6 years ago

Hi Anonymous 

 

Thanks for the reply. I'm not entirely sure how to apply the blog post to my report. It seems to be more adding up totals rathet than filtering years shown. 

 

Thee the only functions in the data are switches to change the format.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI EpicTriffid ,

    AFAIK, power bi visual will auto-hide blank/empty records, but it not work on your side. Can you please share some dummy data with same data structure for test? 

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng