Forum Discussion
Difference between two dates and using additional filters together with all except
Super Usermusafasih
Can you share some sample data and the expected result to have a clear understanding of your question?
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
https://drive.google.com/file/d/13ZjiJ6gWGvL33Z1J8XTkdu9XprnnZ6OP/view?usp=sharing
Fowmy Here is a link to the dummy data in MS Excel which I have created. The original data is company data so Im not allowd to share it. So basically what I am trying to do is to find out the difference (in PowerBI) between first and last date of each transaction code. My ultimate aim is to find out the difference between the date an invoice was issued to customers and the date at which the customers paid for that invoice. The goal is to find out the average days customers take to pay. I had earlier used 'all except' function to group the transactions according to the transaction code and then find out first and last date for each transaction code, but I want to omit the following: ref no with CR BATCH entry; transaction types excluding IN and CR. Also, if I can somehow write a dax formula that will only calculate the difference in days where the first entry is invoice(IN) and last cash received (CR) that would be great. Thank you.
Kind regards,
Musa