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 transactions" that I would put in this table (in the blue) to have it for each products.
I was at first thinking to use Count and Distinctcount to find the solution but it wasn't the results expected. I'm maybe missing something very easy, but I currently don't see it...
Do you have a tips on how I could do please?
(Picture of the final results expected)
Thank you very much !!
Henri Dethoor
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.
7 Replies
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.
Anonymous Hi. Could share your DAX code?
Hi Anonymous
you can use countx funtion to calculate the number of days as mentioned below.
=countx(values(product),count(product))
you can share the pbix file or you dax formula if this not helps.
Please mark this as solution if this helps you.
Hello, thank you for your answers! I tried to look for my DAX code but I didn't find how I should do (I'll make some research for my next topics about how I need to do). For the moment you can find my data in this link. You don't need to mind about all of them: Only the page "Task 2PTS" and "Tooltip3" + the tables Blaknes / Employee / Products / Receipt can be used.
I tried your solution with Countx but it didn't made the solution I expected sorry. I tried with different values also!
Thank you everyone.
- day count = calculate(DISTINCTCOUNT(Orders[Order Date]))in your case its transaction datewhen you drag that measure to the matrix table it will gives catogery wise count of days.
