Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Powerquery – only pull data from weeks that have fully ended

Hi all, I’m importing a table with sales data using powerquery. That sales data has a delay of roughly two weeks, and it’s updated and coming in every day. It looks somewhat like this:   Date ...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    5 years ago

    Hi Anonymous ,

    How about when Grouping By weeks add a Distint Count of Date column and then rule out the ones not being equal to 7?

     

Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
5 years ago

Hi Anonymous ,

How about when Grouping By weeks add a Distint Count of Date column and then rule out the ones not being equal to 7?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Payeras_BI  that is a brilliant and simple solution, works perfect! Thank you for the quick reply!

    best regards

    Bas