Forum Discussion

JeevanMallya's avatar
JeevanMallya
Resolver II
2 years ago
Solved

Filter rows in query editor up to current Week

I have a Table where i doing Fill down Null values for Reported_Cummulative and Closed_Cummulative for All the Future Weeks. But i would like to filter data untill Current Week Rather than doing it ...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi JeevanMallya 

    I have created one calculated column in Power Query to dynamic filter
    Please update the code as per your requirement

     

    = if [WEEK_NUM] > Date.WeekOfYear(DateTime.LocalNow()) then "Greater Than Current Week" else "Less Than Current Week"

     


    If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi JeevanMallya 

I have created one calculated column in Power Query to dynamic filter
Please update the code as per your requirement

 

= if [WEEK_NUM] > Date.WeekOfYear(DateTime.LocalNow()) then "Greater Than Current Week" else "Less Than Current Week"

 


If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin