Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
what measure can show the date which will be in 60,120 days
if I have a date 07/10/2021 it should show 06/12/2021
thanks for the help
Solved! Go to Solution.
try this:
Measure=
IF (
ISBLANK ( MAX ( Table[Date of purchase] ) ),
BLANK (),
CALCULATE ( MIN ( Table[Date of purchase] ), REMOVEFILTERS ( 'Table' ) ) + 60
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @DimaMD
add 60 to the date, for instance:
measure = today()+60 or
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi, @VahidDM
This measure is great, but I have a table and I have to see the payment date which will be the date in 60-120 days
Example table
Shopper ID | Date of purchase | Payment date 60 days | Payment date 120 days |
1 | 01.08.2021 | ||
2 | 05.07.2021 | ||
3 | |||
4 | 07.10.2021 |
My measure is
Shopper ID | Date of purchase | Payment date 60 days | Payment date 120 days |
1 | 01.08.2021 | 30.09.2021 | |
2 | 05.07.2021 | 03.09.2021 | |
3 | 28.02.1900 | ||
4 | 07.10.2021 | 06.12.2021 |
try this:
Measure=
IF (
ISBLANK ( MAX ( Table[Date of purchase] ) ),
BLANK (),
CALCULATE ( MIN ( Table[Date of purchase] ), REMOVEFILTERS ( 'Table' ) ) + 60
)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
@VahidDM
Working measure, Thank you very much
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
13 |
User | Count |
---|---|
107 | |
55 | |
28 | |
19 | |
14 |