Forum Discussion
Solved
Difference between last date and next one
Hi, I am completely new to power bi. I have a table with appointments for customers by their id. each id number can have multiple appointment dates. i am trying to find the number of days since t...
Hi,
Hope this helps.
Thank you so much. Just a a follow up though, some of the tables only had one date and so the numbers are huge, like 43000. How can I add the condition that if 2ndlastday does not exist, then do not subtract or maybe just return the date?
Hi,
Try this measure
=IF(ISBLANK([Second last date]),BLANK(),[Days since previous appointment])