Forum Discussion
Count rows with the same date
Hi, I have data like below. Now, I want to count how many journals were closed and how many journals were opened on a particular date. How to do this? Sample file: https://drive.google...
I have came across this and have a solution for you...
You can unpivot the Created date and Closed date columns in Query Editor. Please refer this link below:
https://www.newtechdojo.com/unpivot-columns-in-power-bi/
Try and please do reply for any more clarifications. Cheers !!!!!!
Deepan