cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Anonymous
Not applicable

## How to take difference of data from first day of last month with first day of previous last month

Hello Friends,

I stuck on some issues calculating the difference between two rows.

I have a running hour of equipment which is always increasing and data saved in excel on daily basis.

I wast BI to calculate the difference from the first day of every month.

I want to calculate the yellow highlighted rows.

Thanks

Asif

4 REPLIES 4
Community Support

Hi @Anonymous ,

Did the above post solve your problem?

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Anonymous
Not applicable

or just assume i want to take a difference of each rows, last-previous

Memorable Member

Hi,

If I understood correctly, You want to calculate the amount for the first of the month - Amount for the first of the previous month.

For this purpose you could use the below code for creating the measure :

Hoist Diff =
Var __FistOfMonthVal = CALCULATE(values(Sheet68[hoist]), STARTOFMONTH(Sheet68[Date]))
Var __PreviousMonthVal = CALCULATE(sum(Sheet68[hoist]), DATEADD( STARTOFMONTH(Sheet68[Date]), -1, MONTH))
var Result = __FistOfMonthVal - __PreviousMonthVal
Return Result

Appreciate your Kudos and please mark it as a solution if it helps you.

Mahyartf
Super User

Hi,

I am not sure about how your datamodel looks like, but if your filter context is Date level, please try using DATEADD DAX function in your measure.

DATEADD – DAX Guide

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors