Solved: Re: How do I get the total number(count) of a row?

anioko1 · ‎03-22-2016

I am trying to learn Power BI and I have a dataset that has more than 5 million rows. I've used the date type to filter things to start from a certain date until a certain date. How do I determine the number of rows that I have without waiting for Power BI to load them?

Manually it takes forever to get the number of rows.

ImkeF · ‎03-22-2016

Your question is not clear to me: Which function are you using that you are requested to give a number of rows?

If I wanted to filter a table from Date A to Date B, I'd check the date column and choose the filters there.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

GabrielPinzon · ‎04-06-2017

The best option is to create a new column that has the index starting at 1, and from this way the number of that index is the number of the record or row.