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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
annejeel
New Member

Difference between two dates without using DAX

Hello oracle. 

 

I am VERY new to Power BI and DAX is terrifying to me, so, please be gentle 🙂 

 

I want to work out the amount of time (in days) between two dates. I'd like to work this out for the single dates but also looks at averages across all of the dates. Is this possible?, and is it possible to do without using DAX as I'm completely clueless there? 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi  @annejeel ,

Pls test the below:(difference)

= Table.AddColumn(#"Changed Type", "Custom", each let 
s = [date1],
e =[date2],
x =
List.Generate(
()=>s,
each _<=e,
each Date.AddDays(_,1)
),
l = List.Select(
x,
each Date.DayOfWeek(_,Day.Monday)<5
)
in 
List.Count(l))

vluwangmsft_0-1653385723908.png

Average:

= Table.AddColumn(#"Changed Type1", "Custom2", each List.Average(#"Changed Type1"[datediff]))

vluwangmsft_1-1653385764999.png

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi  @annejeel ,

Pls test the below:(difference)

= Table.AddColumn(#"Changed Type", "Custom", each let 
s = [date1],
e =[date2],
x =
List.Generate(
()=>s,
each _<=e,
each Date.AddDays(_,1)
),
l = List.Select(
x,
each Date.DayOfWeek(_,Day.Monday)<5
)
in 
List.Count(l))

vluwangmsft_0-1653385723908.png

Average:

= Table.AddColumn(#"Changed Type1", "Custom2", each List.Average(#"Changed Type1"[datediff]))

vluwangmsft_1-1653385764999.png

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Hariharan_R
Solution Sage
Solution Sage

Hi

 if you want to find the difference between two dates then you can achieve it in Power Query editor like below. Share some sample data and also show the expected result to help more. 

 

Hariharan_R_0-1652975598751.png

Hariharan_R_1-1652975693104.png

Thanks

Hari

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors