Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Everyone,
I'm trying to get the difference between the date at the current row and the date from a previous row, similar to the table below.
Would any of you know how to create the column in red font below?
Date | Previous Date | Difference |
June 18, 2020 | - | - |
November 15, 2020 | June 18, 2020 | 150 |
March 2, 2021 | November 18, 2020 | 107 |
Solved! Go to Solution.
Hi, @atacuboy
If you are looking for creating a column, try something like below.
previous date column =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( 'Table', 'Table'[Date] < EARLIER ( 'Table'[Date] ) )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
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.
Hi, @atacuboy
If you are looking for creating a column, try something like below.
previous date column =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( 'Table', 'Table'[Date] < EARLIER ( 'Table'[Date] ) )
)
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
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.
Thank you so much!
@atacuboy , Create a new column like
datediff([Date], maxx(table, [Date] < earlier([Date]),[Date]), day)
Thank you also for replying!
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |