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 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 |
---|---|
94 | |
79 | |
75 | |
64 | |
60 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
61 |