' AND' option between 2 dates columns

Question

HI,&nbsp;I have 2 tables, one is accounts and their&nbsp;'creation' date and the other is account's&nbsp;transactions and the approval date of each transaction.&nbsp;I would like to calculate&nbsp;the sum of transactions&nbsp;of accounts that created and their transaction approved&nbsp;in the date range that ill choose.&nbsp;in simple code it's like this:&nbsp;&nbsp;date(mt.Lv_ApprovedOn) between date(date_range_start) and date(date_range_end)&nbsp; and date(ac.createdon) between date(date_range_start) and date(date_range_end)&nbsp;Thanks&nbsp;&nbsp;&nbsp;

v-piga-msft · Answer

Hi&nbsp;Guyakobov&nbsp;,
&nbsp;
To understand your scenario better, please share your data sample and your desired output so that we could help futher on it.
&nbsp;
Reference:
&nbsp;
How to Get Your Question Answered Quickly
&nbsp;
Best&nbsp; Regards,
Cherry

guyakobov · Answer

HI,&nbsp;You can see&nbsp;in the table attached (http://prntscr.com/msjsfn)&nbsp; that we have an account ('lv_account') and we can see all of his transactions ('count') and their&nbsp;approval&nbsp;date ('lv_approvedon'). in the last column&nbsp;('deposit reg.createdon') we have the date that the accounts were created.&nbsp;I want to choose, for example, July&nbsp;data, and I would like to receive&nbsp;all the accounts that were created on July and get their&nbsp;transactions in that same time frame that I choose ( July in our example).&nbsp;The transactions that supped to appear are highlights in the picture.&nbsp;Regards&nbsp;&nbsp;

guyakobov · Answer

HI,&nbsp;The data sample is here&nbsp;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&nbsp;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.&nbsp;and i want it to be like this&nbsp;http://prntscr.com/mt30le&nbsp;

v-piga-msft · Answer

Hi&nbsp;Guyakobov&nbsp;,
&nbsp;
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?
&nbsp;
If it is, I'm afraid that you just create the measure like below and then you will get the result.
&nbsp;
Measure = CALCULATE(SUM('Table1'[Count]),ALLSELECTED(Table1))

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

guyakobov · Answer

HI,&nbsp;The slicer is date range by days&nbsp;http://prntscr.com/mtif8x .&nbsp;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.&nbsp;Thanks&nbsp;

Forum Discussion

Related content

DMV Column Output Definitions and Options

Datatable options

Monitor option

What has happened to expanding down at column level options? (+/- Row Options)

Source option missing