Returning values based on a filter of greater than or equal to

[Anonymous]

Hi, I have merged 4 tables together to display the following table. TThis all relates to one customer, which i have removed due to privacy issues. What I was wanting assistance with is to make the final column 'DM faddere 2018 hentet fra Donasjoner .Betalingsdato' following the other column in data sequence (chronologically). So that the first row (08.12.17) in 'DM faddere 2018 hentet fra Donasjoner .Betalingsdato comes before 'Startsdato', and then the second row (8.1.18) comes after 'Velkomstpakke sendt' and before AG skjema'. I believe I would need to make new columns for these and then place them in the date sequence that I am wanting but first I need help with how I return the data value based on a greater than function. Is that possible? I would appreciate anyones help on this matter. Thank you:) Maria

[Anonymous]

I'm not sure how i upload the table

[Anonymous]

[Anonymous]

[v-danhe-msft]

Hi @Anonymous,

Sorry, I am afraid you have not uploaded your sample data, could you please upload your sample data and post your desired result if possible?

Regards,

Daniel He

[Anonymous]

Hi Daniel, I'm not sure why this is not working. Can I email this directly to you? Thank you, Maria

[Anonymous]

I know. I'll try it this way. Kundenummer ID Key | DM Vervegiro.Kampanjeaktivitet | Startdato Velkomstpakke sendt | AG skjema mottatt | Nets_startdato (Avtalegiro)| DM faddere 2018 hentet fra Donasjoner.Betalingsdato | XXXX 2017 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 08/12/2017 00:00 XXXX 2018 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 08/01/2018 00:00 XXXX 2019 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/02/2018 00:00 XXXX 2020 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/03/2018 00:00 XXXX 2021 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/04/2018 00:00 XXXX 2022 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 22/05/2018 00:00 XXXX 2023 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/06/2018 00:00 XXXX 2024 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/07/2018 00:00 XXXX 2025 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/08/2018 00:00 XXXX 2026 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/09/2018 00:00 XXXX 2027 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 22/10/2018 00:00 XXXX 2028 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/11/2018 00:00

[Anonymous]

How I would like it: Sorry it is disjointed but this is the best i could do. Kundenummer ID Key DM Vervegiro.Kampanjeaktivitet DM faddere 2018 hentet fra Donasjoner.Betalingsdato XXXX 2017 JuleDM 08/12/2017 00:00 11/12/2017 00:00 Velkomstpakke sendt DM faddere 2018 hentet fra Donasjoner.Betalingsdato AG skjema mottatt Nets_startdato (Avtalegiro) 11/12/2017 00:00 08/01/2018 00:00 22/01/2018 00:00 02/02/2018 00:00 DM faddere 2018 hentet fra Donasjoner.Betalingsdato DM faddere 2018 hentet fra Donasjoner.Betalingsdato 20/02/2018 00:00 20/02/2018 00:00 Does this help?

[Anonymous]

I know. I'll try it this way. Kundenummer ID Key | DM Vervegiro.Kampanjeaktivitet | Startdato Velkomstpakke sendt | AG skjema mottatt | Nets_startdato (Avtalegiro)| DM faddere 2018 hentet fra Donasjoner.Betalingsdato | XXXX 2017 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 08/12/2017 00:00 XXXX 2018 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 08/01/2018 00:00 XXXX 2019 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/02/2018 00:00 XXXX 2020 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/03/2018 00:00 XXXX 2021 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/04/2018 00:00 XXXX 2022 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 22/05/2018 00:00 XXXX 2023 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/06/2018 00:00 XXXX 2024 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/07/2018 00:00 XXXX 2025 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/08/2018 00:00 XXXX 2026 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/09/2018 00:00 XXXX 2027 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 22/10/2018 00:00 XXXX 2028 JuleDM 11/12/2017 00:00 11/12/2017 00:00 22/01/2018 00:00 02/02/2018 00:00 20/11/2018 00:00 How I would like it: Sorry it is disjointed but this is the best i could do. Kundenummer ID Key DM Vervegiro.Kampanjeaktivitet DM faddere 2018 hentet fra Donasjoner.Betalingsdato XXXX 2017 JuleDM 08/12/2017 00:00 11/12/2017 00:00 Velkomstpakke sendt DM faddere 2018 hentet fra Donasjoner.Betalingsdato AG skjema mottatt Nets_startdato (Avtalegiro) 11/12/2017 00:00 08/01/2018 00:00 22/01/2018 00:00 02/02/2018 00:00 DM faddere 2018 hentet fra Donasjoner.Betalingsdato DM faddere 2018 hentet fra Donasjoner.Betalingsdato 20/02/2018 00:00 20/02/2018 00:00 Does this help?