Dico
Member
- Joined
- May 23, 2020
- Messages
- 41
- Reaction score
- 0
- Points
- 6
- Excel Version(s)
- 2019 Pro Plus
Hi,
Please excuse me if the subject is not in the right thread,
I would like that if the invoice dates with the "Fallen On" column greater than the "Export to" column then to indicate the amounts in a new "Not failed" column.
I currently made the Pivot table using Power Pivot.
Moderator edit: related threads: https://www.excelguru.ca/forums/showthread.php?10762-Power-Pivot-with-expiry-and-not-expiry-date
https://chandoo.org/forum/threads/power-pivot-with-expiry-and-not-expiry-date.44839/
I don't know if we have to go through DAX or if we can get that with Simply with Pivot Table or Power query.
Thank you in advance
Please excuse me if the subject is not in the right thread,
I would like that if the invoice dates with the "Fallen On" column greater than the "Export to" column then to indicate the amounts in a new "Not failed" column.
I currently made the Pivot table using Power Pivot.
Moderator edit: related threads: https://www.excelguru.ca/forums/showthread.php?10762-Power-Pivot-with-expiry-and-not-expiry-date
https://chandoo.org/forum/threads/power-pivot-with-expiry-and-not-expiry-date.44839/
I don't know if we have to go through DAX or if we can get that with Simply with Pivot Table or Power query.
Thank you in advance
Attachments
Last edited by a moderator: