Forum Discussion

PeterChu's avatar
PeterChu
Frequent Visitor
7 years ago
Solved

Dynamic calculation between a dynamic time interval

Hi Everyone,

Here is the souce table looks like. It has every member's deposit record.

 

I want to know how many members which deposit more than 20 thousand between a dynamic time interval.

Ex : 2018-08-01 ~ 2018-08-10 / 2018-08-01 ~ 2018-09-15 / by week / by month

I already tried to create a measure like this [Over20000 = CALCULATE(DISTINCTCOUNT('Table1'[MemberId]),FILTER('Table1',SUM('工作表1'[Money]) >= 20000))], but the value is wrong.

 

My test file is in googledrive.

https://drive.google.com/open?id=1l-32kAzQ3J8h0r7JFB0cK-x7PjF2kre4

 

Thank you all.

  • Hi,

     

    You may download my PBI file from here.  Click on the two down headed arrows (see image below where the tooltip is) to drill down to further 2 levels.

     

    Hope this helps.

     

1 Reply

  • Hi,

     

    You may download my PBI file from here.  Click on the two down headed arrows (see image below where the tooltip is) to drill down to further 2 levels.

     

    Hope this helps.