Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Most probably, it is super easy, but I don't know how to do this in one formula. Please help.
I have a column 'ClientEndDate' with empty values (not a client), dates in the future (our current clients), dates in the past (our lost clients).
I need to calculate the number of lost clients.
I understand that I need to do the following steps:
Please help me to create a formula.
Thanks
Solved! Go to Solution.
Measure = COUNTROWS(FILTER('Table',NOT(ISBLANK([ClientEndDate]))&&[ClientEndDate]<TODAY()))
Hi,
Share a sample dataset and show the expected result on that sample
Measure = COUNTROWS(FILTER('Table',NOT(ISBLANK([ClientEndDate]))&&[ClientEndDate]<TODAY()))
For some reason the formula you provided is counting more than the dates prior to today. I have a column ("(*) BL Project Finish") in a table ("TASK") that has dates and I want to count the dates in that column that are before today. I tweeked your formulate to fit my data but it is counting more than the dates that are not blank and prior to TODAY. Here is the formula I am using:
Greg, thank you so much! It worked perfectly well 🙂
User | Count |
---|---|
93 | |
85 | |
77 | |
67 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |