Data Analysis Expressions (DAX) in Power BI
Data Analysis Expressions (DAX) is a powerful formula and query language used in Microsoft Power BI, Excel Power Pivot, and Analysis Services to perform calculations and manipulate data. It allows users to create custom metrics, measures, and calculated columns, enabling
Configure PHPMYADMIN to connect to different servers
Here are the steps to set up PHPMYADMIN to connect to database servers located at different ip addresses: 1. Open config.inc.php located in C:\xampp\phpMyAdmin directory in windows and located in /etc/phpmyadmin directory in Ubuntu. 2. Add the below written code
Devextreme | Invoke Custom Loader on click of any button
Invoke Inbuilt Custom Loader in Devextreme Mvc datagrid on ‘Save’ click from Insert popup. In Devextreme Mvc datagrid, I used the Popup mode for adding new data with the following way to make api controller call on Insert Action. Below
MySql | Show only columns as rows which have specific value
Sometimes, we want to show only those columns which have specific value. Let’s assume we have following table : In the above table, value of 1 in a column represents that corresponding service is provided by organization and 0 represents
CakePHP | Get user profile information through Gmail API (2.2.0)
Steps to extract user profile information through Gmail API (2.2.0) in CakePHP: 1. Set up developer test account inside google API developer console: Use https://console.developers.google.com/ link to open developer console. Add new project inside your developer console and enable the
WordPress | How To Add Custom Color Picker in WordPress Custom Options Panel
While building options panel in functions.php of your child-theme, we can create our custom color picker without using any plugins. We have to follow these steps and for this color picker : 1. Add Canvas <canvas id=”image_canvas” width=”246px” height=”210px”></canvas> 2 .
Salesforce | Roll back changes or delete unused classes/triggers from Production
There are two most common ways to revert your changes back to Salesforce sandbox from production: 1.) Force.com IDE 2.) Salesforce Migration tool (ANT) Using Force.com IDE : If you are already using force.com IDE then you can go for
Some Useful Features from jquery and Html5
1. Data attribute : This is the new attribute in html5. Using data attribute we can store custom data in any of the html elements. Data attribute consists of a prefix “data-” and a unique name appended to the prefix.
CakePHP | Date format translation using internationalization
In Cakephp, To translate the application language into another, we use internationalization and localization. To display the correct translated date string on change of locale, we need to use right classes. use Cake\I18n\I18n; use Cake\I18n\Time; I18n::Locale(‘es’’); // es locale is
Moodle | Totara | Create bulk enrollments from command line
1. Go Home ► Site administration ► Development ► Debugging and set Debug messages with “DEVELOPER: extra debug messages for developers”. 2. Create a testcourse.bash file in root directory with : for i in {1..100} do var=”Course_from_script_$i” echo $var php
