Forum Discussion
Begginer question: Basic calculation formula
Hello, I'm stuck since 2 hours on something very basic and I really have no idea on how to do. I have 8000 transactions like this and I need to calculate the "Amount Of Days that have transact...
Hi Anonymous
I got the solution for you problem. You can drag date column from receipt table. I have attached screenshot below for your reference.
Please mark this as solution if it works.
day count = calculate(DISTINCTCOUNT(Orders[Order Date]))
in your case its transaction date
when you drag that measure to the matrix table it will gives catogery wise count of days.
Hello! I've already tried this possibilty and as you can see in the screenshot I just get 31 everywhere. While my results should be: 87,85,88... Thank you for trying