Forum Discussion

Guyakobov's avatar
Guyakobov
Helper II
7 years ago

' AND' option between 2 dates columns

HI,   I have 2 tables, one is accounts and their 'creation' date and the other is account's transactions and the approval date of each transaction.   I would like to calculate the sum of transact...
Need Help
Guyakobov's avatar
Guyakobov
Helper II
7 years ago

HI,

 

The data sample is here https://prnt.sc/msjsfn - you can see in that table that we have one account that was created in July and did a few transactions in July and more transactions after. so, if ill choose in my date filter all of July I suppose to see only the accounts that were created ON July and the transaction that was approved on July cause this is the time frame that I chose.

 

and i want it to be like this http://prntscr.com/mt30le 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Guyakobov ,

     

    Based on your information, it seems that you have a slicer and you want to show the sum of count based on the selected month?

     

    If it is, I'm afraid that you just create the measure like below and then you will get the result.

     

    Measure = CALCULATE(SUM('Table1'[Count]),ALLSELECTED(Table1))

     

    If you still need help, please share more sample data which could reproduce your scenario so that we can help further on it.

     

    Best  Regards,

    Cherry

    • Guyakobov's avatar
      Guyakobov
      Helper II
      7 years ago

      HI,

       

      The slicer is date range by days http://prntscr.com/mtif8x . so for example, if ill choose in my date range 20/7/18 till 30/07/18 I shouldn't see any information because the account was created on the 9/07/18.

      the date slicer needs to consider both 'created on' dates and 'approved on' dates.

       

      Thanks