Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
Can anyone help me how to create a dax formula to find "Previous Available" date for each "ID".
Date's are not continuiously existed for each ID (gaps in dates).
Please take the image as reference, for product "A" I supposed to get "sep 20/2022". Eventhough it is having 19th Sep as min date.
Need to show the previous available day for each product
Thanks in advance
Hi @Anonymous ,
Swap FirstDate for PREVIOUSDATE and see if that works.
Did I help you today? Please accept my solution and hit the Kudos button.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |