Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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))
Average:
= Table.AddColumn(#"Changed Type1", "Custom2", each List.Average(#"Changed Type1"[datediff]))
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
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))
Average:
= Table.AddColumn(#"Changed Type1", "Custom2", each List.Average(#"Changed Type1"[datediff]))
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
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.
Thanks
Hari
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
103 | |
101 | |
76 | |
66 | |
60 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |