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.

vishalgupta29's avatar
vishalgupta29
Frequent Visitor
4 years ago

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.