Forum Discussion
' 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...
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
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