Forum Discussion
Looping Logic
Hello Community, i have a table below. Need to calculate the count of Newvalue column based on Date selection. Please observe below output exmple results for your reference. TABLE: Prop ...
Hi Ibendlin,
Need to count the Newvalue column Dynamically based on Max Of createddate in the selected daterange.
Source table:
---------------
| Prop ID | Created Date | New Value |
| ABC123 | 5/3/2023 | Signed |
| ABC123 | 4/29/2023 | Accepted |
| ABC123 | 4/26/2023 | Pending |
| XYZ123 | 4/20/2023 | Signed |
| XYZ123 | 4/17/2023 | Accepted |
| XYZ123 | 4/8/2023 | Pending |
example1:If User select above Date range
Expected Result:
Note: The count should be come under newvalue column based on dynamic maxdate.
User Selection (Slicer): 04/17/2023 to 04/20/2023
| Prop ID | Created Date | New Value | Count |
| ABC123 | 4/26/2023 | Pending | 1 |
| XYZ123 | 4/17/2023 | Accepted | 1 |
Thanks
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
