Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Data:
Product | Date |
A | 1-Apr |
A | 2-Apr |
A | 3-Apr |
B | 1-Apr |
B | 2-Apr |
C | 1-Apr |
To get previous date
i need
if there is previous date even if current date is blank then show me
Solved! Go to Solution.
Hi @ddpl ,
A table of dates needs to be created (no need to create a relationship). Then create the following formula that will get the blank values.
MEASURE =
IF (
ISBLANK ( [Pre_Dt] ),
CALCULATE ( MIN ( 'Table'[Date] ), 'Table'[rank_] = 1 ),
[Pre_Dt]
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ddpl ,
A table of dates needs to be created (no need to create a relationship). Then create the following formula that will get the blank values.
MEASURE =
IF (
ISBLANK ( [Pre_Dt] ),
CALCULATE ( MIN ( 'Table'[Date] ), 'Table'[rank_] = 1 ),
[Pre_Dt]
)
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |