Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I have data like below, Duplicates of drw-No, if release date is null, No of days = 0, if minnimum release date of draw_no having date, No of days = release date - previous date of release date, if previous date of release date null, No of days = release date- previous date of revision date.
S.No | Draw_No | Rev | Revision Date | Release date | No of days | explanation |
1 | 0001 | A | 12/01/2023 | null | 0 | Release date = null, 0 |
2 | 0001 | B | 18/01/2023 | 12/02/2023 | 28 | 12/02/2023 - 12/01/2023 |
3 | 0001 | C | 19/02/2023 | 12/03/2023 | 30 | 12/03/2023- 12/02/2023 |
4 | 0002 | D | 1/03/2023 | 19/04/2023 | 0 | |
5 | 0002 | E | 1/05/2023 | 11 | 1/05/2023 - 19/04/2023 | |
6 | 0002 | F | 12/05/2023 | 12 | 12/05/2023 - 1/05/2023 | |
0001 | G | 12/06/2023 | 90 | 12/06/2023 - 12/03/2023 |
How can I write dax formula to get above result, please support me if any know the solution.
Thanks,
Maneesha.
Solved! Go to Solution.
Hello @ManeeshaY_12345 ,
can you please check if this is what you want :
Hello @ManeeshaY_12345 ,
can you please check if this is what you want :
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |