In this article, we have explained how to calculate the RATIO between two number in Excel. We have used the Excel formula as well as the User defined function in
Shell Function in VBA can run executable program and returns a Variant (Double) representing the program's task ID if successful otherwise, it returns zero. Syntax Shell(pathname, [ windowstyle ]) pathname:
PKComments Off on KPI in Power Pivot for dashboard and report
Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI is designed to help users quickly evaluate the current value and status of
In this article, we have explained how to use Measure in Pivot Pivot data model. We have taken the example of SUMX function to calculate the revenue. On the base
PKComments Off on Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)
In this article, we have explained how to use calculated column in Power Pivot Data Model. We have taken the example of Orders data wherein we have product level Unit
PKComments Off on Drill Down/Drill Up Feature in Pivot Chart
In this article, we have created a drill down/drill up functionality in a Pivot chart. We have created a hierarchy in Power Pivot data model to create this. Below are
PKComments Off on Create Relationship in Power Pivot
In this article, we have explained, how to create relationship in Power Pivot data model. We have taken 2 dimension table and once fact table. What is Power Pivot? Power
PKComments Off on Sales Dashboard Power View in Excel 2013
In this article, we have created a beautiful Sales Dashboard using Power View in Excel 2013. [caption id="attachment_22871" align="aligncenter" width="964"] Power View in Excel[/caption] What is Power View? Power View
PKComments Off on Dynamic Conditional Formatting in Power BI
In this article, we have created a Power BI dashboard with dynamic condition formatting. We have created to measure in Power BI using DAX to create the dynamic Conditional Formatting
PKComments Off on Smart Data Entry form with minimum VBA
In this article, we have a data entry form for candidate information with minimum VBA. We have used Excel formulas, conditional formatting and Form Controls. You can replicate this template
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy PolicyACCEPT
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.