Forum Discussion

Mischa2710's avatar
Mischa2710
Copper Contributor
Apr 16, 2020

Power Query only load filtered rows

I´ve a spreadsheet with filtered rows. I´d like to load only the already filtered data to PowerQuery.  Is there a way to do this?
excel
power bi
JKPieterse's avatar
JKPieterse
Silver Contributor
Apr 16, 2020
Devious. I must study that AGGREGATE function more!
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 16, 2020

JKPieterse 

=(SUBTOTAL(3,[@A])=1)+0

works the same way 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 16, 2020
    Back in the day that didn't work because filtering did not necessarily trigger a calculation
      • Mischa2710's avatar
        Mischa2710
        Copper Contributor
        Apr 20, 2020

        SergeiBaklan 

        JKPieterse 

        Hey guys,

        thanks for your support. Was really very helpful. Today, I had time to try it.

         

        The last question I have, I understand the result/idea behind of +0, but I don´t understand how it works.

        Can you explain this, please.

         

        TX

        Michael

Resources