DAX Variables in PowerBI-Subtracting Prior Value from Current Value of a Column

DAX-VARIABLES-POWERBI (2)

Table of Contents

DAX Variables in PowerBI-Subtracting Prior Value from Current Value of a Column

DAX Variables in PowerBI-Subtracting Prior Value from Current Value of a Column



My Friend got a Scenario where he was asked to subtract the prior value from the current value of the column. I helped him by finding the Solution on the Microsoft community I did not find the correct solution on it.


I have prepared the demo for describing the solution for the problem “Subtracting Prior Value from Current Value of a Column in Power BI “

So Let`s Start!!!




Step 1: I have created a dummy table “YearRevenue Table” with columns Revenue and Years.



Step 2: Now Create a Measure in the same table and place the DAX code mention below:

Diff = VAR Currentyear= MAX(‘YearRevenue Table'[Years])
VAR PreviousYears=MAX(‘YearRevenue Table'[Years])-1
VAR CurrentValue=CALCULATE(SUM(‘YearRevenue Table'[Revenue]),’YearRevenue Table'[Years]=Currentyear)
VAR PREVIOUSVALUE=CALCULATE(SUM(‘YearRevenue Table'[Revenue]),’YearRevenue Table'[Years]=PreviousYears)
VAR result= CurrentValue-PREVIOUSVALUE
return result



Step 3: After creating a Diff measure using the dax code, Place all the columns in the table
in Power View.

I hope the solution will help the developer to implement it in their report.

Categories
INDEXES
Database
Kaushlendra Mishra

What are Indexes in SQL Database? What is the advantage and disadvantage of Indexes?

Indexes are schema objects in a SQL database that can boost query performance while executing queries with a filter condition using where clause.

Indexes are used to retrieve data from databases very fast. An Index is a quick lookup table that is used to find a record that user search very frequently. An index helps to speed up select queries and where clauses, but it slows down data input, with the update and the insert statements.

Read More »

Leave a Comment

Your email address will not be published. Required fields are marked *