Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
LarsPW
Frequent Visitor

Tips on how to Calculate the net result of two columns?

Hi

 

I've a table including two columns, one with entry dates and one with exit-dates.

LarsPW_0-1669900091931.png

 

My wish is to calculate theese two, and recvive the net result per month, thus wheter the result is positive  or negative and then display the result in a bar chart, similar to this:

LarsPW_1-1669900335903.png

I've tried making a measure where I just subtracted the entry with exit column, but it didnt work well.

 

Anyone here with a suggestion how solve this? 

Good to know is also that, the two colomuns are connected to two separate calender tables

1 ACCEPTED SOLUTION
djurecicK2
Super User
Super User

Hi @LarsPW ,

 You can create a calculated column to store the differnce. Something like this:

Difference= DATEDIFF(Tablename[Disaffiliatedate],Tablename[Applicationdate],DAY)

 

https://learn.microsoft.com/en-us/dax/datediff-function-dax

 

Please accept as solution if this answers the question- thanks!

View solution in original post

1 REPLY 1
djurecicK2
Super User
Super User

Hi @LarsPW ,

 You can create a calculated column to store the differnce. Something like this:

Difference= DATEDIFF(Tablename[Disaffiliatedate],Tablename[Applicationdate],DAY)

 

https://learn.microsoft.com/en-us/dax/datediff-function-dax

 

Please accept as solution if this answers the question- thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.