To calculate the difference between two dates in Power BI, you can use the DATEDIFF function. The syntax of the DATEDIFF function is as follows: DATEDIFF( start_date, end_date, interval ) The start_date and end_date parameters should be of type Date or DateTime. The interval parameter specifies the unit of time you want to calculate the … Read more

Postman Nested form-data To send nested form-data in Postman, you can use the key-value pairs where the value is again a nested form-data. This allows you to structure your data in a hierarchical manner, similar to nesting objects in JavaScript or JSON. Here’s an example to demonstrate how to send nested form-data in Postman: Let’s … Read more

How to Calculate Date Difference in Power BI Calculating the date difference in Power BI can be done using the DATEDIFF function. This function allows you to calculate the difference between two dates and returns the result in a specified unit (e.g., days, months, years). Here is an example of how to use the DATEDIFF … Read more

Postman has built-in support for JavaScript to enhance your API testing workflow. To enable JavaScript in Postman, follow the below steps: Open Postman application Create a new request or open an existing one Click on “Tests” tab below the request URL field Write your JavaScript code inside the JavaScript editor Here’s an example of how … Read more

Postman 503 Service Unavailable The HTTP 503 Service Unavailable response status code indicates that the server is currently unable to handle the request due to temporary overloading or maintenance. This means the server is not available at the moment to process the request. Here are some common reasons for encountering a 503 error: Server overloading: … Read more

How to Calculate Current Year Sales in Power BI In Power BI, you can calculate the current year’s sales by following these steps: Create a new measure to calculate the sum of sales for the current year: <measure name> = CALCULATE( SUM(<sales column name>), FILTER( <table name>, YEAR(<date column name>) = YEAR(NOW()) ) ) Replace … Read more

PostgREST for MySQL PostgREST is a web server, written in Haskell, that serves a RESTful API directly from a PostgreSQL database. It automatically exposes the tables, views, and stored procedures of the PostgreSQL database as RESTful endpoints. However, PostgREST is specifically designed for PostgreSQL databases and does not support MySQL out of the box. If … Read more

Calculating Current Month Sales in Power BI Power BI provides the capability to calculate various metrics and analyze data. To calculate the current month’s sales in Power BI, you can follow these steps: Import the Data: Start by importing the data containing the sales information into Power BI. This can be done by connecting to … Read more

PostgreSQL Update Without Lock When updating data in PostgreSQL, the default behavior is to acquire a lock on the affected rows to ensure data consistency. However, there are scenarios where you may want to perform an update without locking the rows, such as reducing contention or improving performance in high-concurrency environments. To achieve this, you … Read more

In order to calculate cumulative sum in Power BI, you can make use of DAX functions such as SUMX and CALCULATE along with some measures. Create a measure to calculate the cumulative sum. Let’s call it “Cumulative Total”. Use the SUMX function to iterate over the rows of the table and calculate the cumulative sum … Read more