KNOW POWER BI

 Sample Project 21 (Hotel Report) click on view interactive content to see the fully functional power bi report... Project Data Set And Snapshots are available in the below link https://t.me/PowerBiProfessinoals/8 For Power Bi-Material, Interview Questions, references, and more please join the below telegram link https://t.me/PowerBiProfessinoals Thank You🙏 P.M.Prasad

 How to set TODAY  as default slicer selection dynamically. (Responsive power bi report included at the end of this post.) Requirement: set today as default slicer selection dynamically. (whenever the report is opened that date should be the default value) source: excel, containing a table named "sales" with 2 columns past, present, future dates as a date column, and sales target values in another column. algorithm 1)creating a dimdate table with the date values in the sales table 2) creating a new column with condition (equating date with today and naming it as "today", and the dated lesser than today(current date) shod be displayed as same dated) 3)removing the blank values Procedure Explanation : creating dimdate table. DIMDATE = CALENDAR(MIN(SALES[Date]),MAX(SALES[Date])) creating a column named "slicer date" in dimdate table for slicer selection. slicer date = IF(DIMDATE[Date]=TODAY(),"Today",IF(DIMDATE[Date]<TODAY(),DIMDATE[Date]&...

 AP EAMCET 2020 COUNSELING REPORT HOW TO USE THIS REPORT : > SELECT ANY SELECTION TO GET THAT PARTICULAR OUTPUT. DEFAULT SELECTION IS ALL. > DESELECT ANY SELECTED OPTION TO GET BACK TO DEFAULT ALL VALUES. >YOU CAN SELECT MULTIPLE OPTIONS IN ANY SELECTION DROP-DOWN LIST. # RANK SELECTION: >( CLICK ON RANK COLUMN HEADING FOR ASCENDING / DESCENDING ORDER) > IF YOUR RANK IS BELOW 901 YOU HAVE ALL THE COLLEGE OPTIONS. > IF YOU WANT TO SEE ALL THEN COLLAGES > IF YOU WANT TO SEGREGATE THE COLLAGE /BRANCH THAT YOU MAY GET IN THIS YEAR PLEASE SELECT THE RANK BETWEEN OPTION (SET MIN VALUE =2000 BELOW YOUR RANK & MAX VALUE = 2000 ABOVE YOUR RANK (EX: YOUR AP EAMCET RANK =14551 THEN SET RANK BETWEEN VALUES AS 12551 TO 16551) Please follow and share.. Please write your questions & suggestions in comments below Thank you🙏 P.M.Prasad

 Time Intelligence Functions Scenario Requirement:  Calculating YTD,QTD,MTD,Previous month sales,Total Sales, for a User selected period(12 months/24 months) In a single column Using slicer selection. (Power BI interactive report included in the end of this post)  Source Tables: sales table with order date and sales amount Relationships: Created the Dimdate table and established a relationship with the date in Dimdate and order date in the sales table. Created a Total Sales measure: Total Sales = SUM(Sales[SalesAmount]) Using the above Total Sales measure Created a MTD Sales measure: MTD Sales = CALCULATE([Total Sales], DATESMTD(Dimdate[Date])) Created a QTD Sales measure: QTD Sales = CALCULATE([Total Sales], DATESQTD(Dimdate[Date])) Created a QTD Sales measure: YTD Sales = CALCULATE([Total Sales], DATESYTD(Dimdate[Date])) Created a Previous Month Sales measure: Previous months Sales = CALCULATE([Total Sales], ...

  Dynamic Date & Time / Dynamic Digital Watch in Power BI (with Power BI Report Live Example) First Time online, I am presenting a Digital clock/ Time/Dynamic watch in power bI. we all know how to show refresh date-time, which is static and will change only when we refresh the data. but here I'm showing the Date and Time of India dynamically, without manually refreshing the data.  To achieve this I have been created Two Measures for two outputs. and a drill-down                  player visual. Date & Time = UTCNOW()+(5.5/24) here I have been UTC time and added 5.5 Hours to get the Indian time zone. we can use now() also but our power bi Services cloud server will be in a diffrent location, so we won"t get India date & time. To overcome this, I have taken UTCNOW() and added 5:30 min to it. Measure 2 is to show only time, not the date part. Time = format(UTCNOW()+(5.5/24),"hh:mm:ss") To get only time from time an...

 Welcome all to Learn Power BI Blog Welcome to the launch of the new and improved Know Power BI Blog and my first blog post! My name is  P.Mallikharjuna Prasad,  a Professional in Power BI and I am so excited to share with you MORE of what I can offer! The number of ideas, how-to’s, and inspirations whirling around in my head are ready to jump out. I wanted to start by telling you why I created this blog, what you will be seeing more of in my posts and my overall experience of revamping my Blog. Why I started my blog Since I started my Profession in Power BI, many of my friends have asked me “Why don’t you start a blog?!”  After doing much research and making friends with a few bloggers along the way, who have been so kind to offer much support and advice, I have become completely consumed with inspiration to start a blog for Power BI. I have finally realized all of the benefits that blogging can bring. What you will be seeing more of in my posts Power BI will obvio...