When you place a date field into a Pivot Table, and if you are using the 2016 version of Excel you get a hierarchy. But you don't always get that when doing the same in PowerBI.
What is a Date Table? How would you use it? How can it help you calculate the fiscal year? This step-by-step tutorial shows you the benefits of using a date table in Power BI.
The process of Ranking, or assigning a number to a field based on the value is an old but useful one. This tutorial will show you how to use the RANKX function to rank your products by sales.
Computer Tutoring takes your privacy seriously and collects essential information such as your name, email, and course preferences to facilitate our services. Additionally, we use cookies to personalise your experience and for Google Ads personalisation, which helps us deliver more relevant advertising to you.
We do not share your personal data, except for specific use-cases like payment processing via PayPal and sending you updates via Mailchimp, if you've opted in for those services. Our site may also use Google Analytics to improve user experience and features links to other websites. Please be aware that Google's Privacy Policy may differ from ours.
We do not store your credit/debit card details. You have the right to access, amend, or request deletion of your personal data by contacting us at info@computertutoring.co.uk.
By using our website, you consent to our use of cookies for the purposes outlined above.
For more details, please read our full Privacy Policy.