Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • vishalgupta29's avatar
    vishalgupta29
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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.

 

https://wetransfer.com/downloads/7ef429368892372619e0a2bea4d5482320220219125527/a70e753875fcc8b77f8f022d2075a14220220219125614/59f0a4?utm_campaign=WT_email_tracking&utm_content=general&utm_medium=download_button&utm_source=notify_recipient_email