Have you just started your journey with Power BI? Are you looking for a dataset that you can use in or connect Power BI to without the fear of slowing down the main database? Or just looking for ways of improving your skills? If you answered yes to any of Read more…
Do you know which one to use? One of them is going to COMBINE queries, while to other one works similarly to LOOKUP in Excel 🧠 It is important to know the difference between these two built-in features as they do vastly different things. If you want to learn all Read more…
And why should you turn it off? By default, Power BI will create a hidden Calendar Table for all of the date-type fields in the data model. This is a really handy feature for new users 👍 It allows them to utilize Time Intelligence features without knowing how to create Read more…
My favorite and most used Time Intelligence ⏲ functions Most companies like to compare different time periods and see if they are doing better or worse than they were before. It can be a comparison to last year, last month, the previous quarter, etc… Setting up these calculations in Excel Read more…