Forum Discussion
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
- Ashish_MathurSuper User
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.