Power Query

What's Like-for-Like (L4L) to be certain that only comparable elements are compared. Elements could be products, stores, customer groups, etc. Here, you possibly can read a good explanation of this topic. In the present case, I'll construct...

This can be a typical case for Self-Service BI with Excel data. Just a few days ago, a client asked me the next query: I actually have an Excel sheet with numbers and text in a...

a question folding?” “Does your query fold?”… Perhaps someone asked you those questions, but you were like: “Query…Whaaaat?!” Or, possibly you’ve heard about query folding in Power BI, but didn’t know the right way...