Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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.
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.