User Profile
alinazarovf
Advocate I
Joined 2 years ago
User Widgets
Contributions
Power BI Uzb. User Group Meetup: Power BI Certifications Tips
We are organizing our first online meetup on the 27th of February, where we can connect, and can share some tips for excelling in the Power BI and Fabric exams (PL-300 / DP-600). The meeting will be conducted in Uzbek language. Biz 27-fevral kuni birinchi onlayn uchrashuvimizni tashkil qilmoqdamiz, bu yerda biz bog'lanib, Power BI va Fabric imtihonlarida (PL-300 / DP-600) muvaffaqiyat qozonish uchun ba'zi maslahatlarimizni ulashishimiz mumkin. Uchrashuv o'zbek tilida o'tkaziladi. Topic: Power BI Uzb. User Group Meetup: Power BI Certifications Tips Time: Feb 27, 2025 07:00 PM Islamabad, Karachi, Tashkent Join Zoom Meeting https://us04web.zoom.us/j/75899083066?pwd=T0R7sD971Jl6d9nso4Uk63UvjFYgzq.1 Meeting ID: 758 9908 3066 Passcode: 89D2KSRe: Uzbekistan Power BI & Fabric User Group - Assalomu alaykum How is it going? @alinazarovfbrother,
Hi muhriddinorif , To use Power BI Service, you need to sign up with a work or school email. It is not possible to use a personal email. If you don't have a work (corporate) email, the best option is to register your personal email (e.g., Gmail) as a corporate user through the Azure, free Microsoft Entra Tenant ID feature. Then, you can log in and use the trial Fabric Capacity for 60 days for free with all premium features. An alternative option is to use the trial version of the Microsoft 365 E5 license, which is free for 1 month (after that it will charge money) and includes a Power BI Pro license: Office 365 E5 (no Teams) - Trial - Sign upRe: Uzbekistan Power BI & Fabric User Group - Assalomu alaykum! @alinazarovf Firdavs aka, from your L
Va Alaykum Assalom, Anonymous, If you have already registered for the exam, you have probably seen the exam structure and the topics to expect. Since you have 5 days left, I will give more general suggestions rather than listing topics to learn. 1. Prepare the room and check your internet speed. Ensure the room is free of any noise and that you have only your laptop on the table. Internet speed was an issue for me during the exam. 2. Microsoft has a great learning path for preparing for the certification exam. I highly recommend watching these: Preparing for PL-300 - Prepare the Data (Part 1 of 4) | Microsoft Learn Preparing for PL-300 - Model the Data (Part 2 of 4) | Microsoft Learn Preparing for PL-300 - Visualize and Analyze the Data (Part 3 of 4) | Microsoft Learn Preparing for PL-300: Manage and secure Power BI (Part 4 of 4) | Microsoft Learn 3. Stay calm and don’t stress. Remember, there is no requirement to pass it on the first attempt. Even if you fail, it is not the end of the world. You will gain experience to pass the next one more easily.Re: Uzbekistan Power BI & Fabric User Group - Hello i am not able to login app.powerbi.com after chan
Hello Sir, FYI, this User Group is more focused on learning in the Uzbek language and developing the local community. So, I think it’s more efficient if you post this question in the Power BI Forum, but I will try to answer your question anyway. I faced a similar issue when I changed my phone. I found a workaround by re-logging into the Authenticator and Company Portal (mobile security apps). After that, I could sign in with no issue.Re: Default filter to show data from the last 6 months but also allowing the user to modify the filter
Hi, I would suggest creating 2 measures. First, the sales amount, which would always show the last 6 months by default for your report. And second sales amount measure with custom (user-defined) dates to compare with the first measure. Part 1. Measure with default filter showing last 6 months sales 1.1 First you need 1 extra measure to avoid showing results in future dates. ShowValueForDates = VAR LastDateWithData = CALCULATE ( MAX ( 'Sales'[Date] ), REMOVEFILTERS () ) VAR FirstDateVisible = MIN ( 'Date'[Date] ) VAR Result = FirstDateVisible <= LastDateWithData RETURN Result 1.2 Create measure for last 6 months data using the following code: Sales amount (last 6 months) = IF ( [ShowValueForDates], CALCULATE ( [your aggregation measure (for example sales amount)], DATESINPERIOD ( 'Date'[Date], MAX ( 'Date'[Date] ), -6, MONTH ) ) ) 2. Custom measure for user-defined period. 2.1 Create one more date table, name it for example comparison dates (it should contain same dates as your main date table). Then connect newly created date table to your main date table, relationship should be inactive, one (comparison date table) -> to -> many (main date table). 2.2. Create your 2nd measure by using comparison dates: Comparison Sales Amount = VAR ComparisonPeriod = CALCULATETABLE ( VALUES ( 'Date'[Date] ), REMOVEFILTERS ( 'Date' ), USERELATIONSHIP ( 'Date'[Date], 'Comparison Date'[Comparison Date] ) ) VAR Result = CALCULATE ( [Sales Amount], ComparisonPeriod ) RETURN Result Custom date filter (for your user to compare 2 sales amount measures) should be from comparison date. Final result should be like this (instead of brand, product name for example): You can find more info in: Standard time-related calculations – DAX Patterns Comparing different time periods – DAX Patterns
