Skip to main content

Posts

Showing posts from October, 2019

Power Apps

Community plan: PowerApps Community Plan gives you access to PowerApps premium functionalities, Common Data Service, and Microsoft Flow for individual use. This plan is primarily meant for learning purposes or creating business solutions to be distributed for AppSource Test Drive. This plan is perpetually available, but only for learning and building your skills on PowerApps, Common Data Services, and Microsoft Flow. It can run unlimited number of apps We can use common data service Connect to Office 365, Dynamics 365 User premium connectors like Salesforce, DB2 Access on premises date using on premises gate way Cloud environments like Azure, SQL, Dropbox, Twitter Can create custom connectors Common data service, Can create run common data service, model your common data service, create database in common data service User roles and access permissions: You can't add co-workers as environment makes and admins Add co-workers to the database role...
Post a Comment
Read more

SharePoint List forms how to customize using JQuery

Here is the solution to customize SharePoint list forms with out using SharePoint designer. This solution is using "Jquery" You can add bootstrap references for custom design Step 1: Create a SharePoint custom list Step 2: Create columns as 1. Person 2. Title (which is out of the box) Step 3: Click on the "new form", or "edit form", or "view form" of out of the box SharePoint List. Step 4: Edit the form Step 5: Add new content editor and refer a .html/.txt custom file where you refer the below code Click on Save Follow the code below: HTML: <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> //Jquery reference <script src="../../SiteAssets/JS/jquery-1.7.1.min.js"></script> <body> <div class="fulldiv"> <label for="" class="ms-font-m-plus" id="taskDesc_task">Title:...
Post a Comment
Read more

Javascript

Once after page loads, your DOM is ready to load the functions $(document).ready(function(){   myFunction(); }); function myFunction(){   alert("Hello World"); } var carsArray = ["Ford", "Maruthi", "Benz", "Audi"]; carsArray.sort(); //to sort the array //To find its value, then seach by its index carsArray[0] means you will get its value as Audi what is JSON array JSON array is array with key and value pair or Object inside an Array. JSON array most popular data format or data model used in current market. var carJsonArra = [{"Teja":29},{"Meena":24},{"Mouni":28}]; carJsonArra[0]// means it gives 0th index value as {"Teja":29} which is a object inside an array carJsonArra.length // gives length of the array means count of objects inside array //Loop the array in javascript var myData = [{Name: 'Teja'},{Name: 'Mouni'},{Name: 'Meena'}] for(var i=0;i...
Post a Comment
Read more

Power BI

Power BI ref guide:  https://docs.microsoft.com/en-us/power-bi/desktop-what-is-desktop Introduction Power BI Desktop is a free application you can install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data, and combine them (often called modeling) into a data model that lets you build visuals, and collections of visuals you can share as reports, with other people inside your organization. Most users who work on Business Intelligence projects use Power BI Desktop to create  reports, and then use the Power BI service to share their reports with others. The most common uses for Power BI Desktop are the following: Connect to data Transform and clean that data, to create a data model Create visuals, such as charts or graphs, that provide visual representations of the data Create reports that are collections of visuals, on one or more report pages Share ...
Post a Comment
Read more

Power BI, IF condition

Create a calculated column that uses an IF function Stores table has a column named Status, with values of "On" for active stores and "Off" for inactive stores, which we can use to create values for our new Active StoreName column. Your DAX formula will use the logical IF function to test each store's Status and return a particular value depending on the result. If a store's Status is "On", the formula will return the store's name. If it’s "Off", the formula will assign an Active StoreName of "Inactive". 1. Create a new calculated column in the Stores table and name it Active StoreName in the formula bar. DAX Expression: Active StoreName = IF([Status]="On",[StoreName],"Inactive") Store Table fields: Final Output:
Post a Comment
Read more

In Power BI, What is RELATED function

DAX formulas can leverage the full power of the model you already have, including relationships between different tables that already exist. We can apply DAX expressions the new column For example, I have "ProductCategory" table and "ProductSubCategory" table Data table fields: Data OutPut: DAX Formula: ProductFullCategory = RELATED(ProductCategory[ProductCategory])& " - " &[ProductSubcategory] from above expression, RELATED is the dax function which will join two columns. ProductFullCategory is the column created in ProductSubCategory table with DAX function. Inside Related function, we have to specify which table we need the columns and its column name.
Post a Comment
Read more