Forum Discussion
How to user enter a date for separate columns in base a specific date: before, month, future
Hi Anonymous ,
Check this file as an example: Download PBIX
I hope it helps.
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
Hi Anonymous ,
I have tested the pbix file that camargos88 did. It should work. If it works for you, please accept the helpful answer as a solution. If you still have questions, please share the expected results. Then we will understand clearly.😉
Thanks Ricardo by your answer, i was thinking create Measure, but How make that the user enter the date for separated 3 columns (before, month (before date until last day of the monthn) future, nex month; example: 15/04/2020.
Thanks by your help Ricardo.
Data Sample
| Code Client | Invoice | Date Invoice | Amount |
| 1 | 1 | 9/23/2019 0:00 | 8910 |
| 1 | 2 | 11/20/2019 0:00 | 7128 |
| 1 | 3 | 4/15/2020 0:00 | 2871 |
| 1 | 4 | 5/26/2020 0:00 | 13678.16 |
| 1 | 5 | 2/15/2017 0:00 | -1.9 |
| 1 | 6 | 2/15/2017 0:00 | -525 |
| 2 | 7 | 5/27/2019 0:00 | -1206.9 |
| 2 | 8 | 4/16/2020 0:00 | -224.1 |
| 2 | 9 | 5/1/2020 0:00 | 1071.4 |
| 2 | 10 | 5/8/2020 0:00 | 806.3 |
| 2 | 11 | 5/18/2020 0:00 | 1342 |
| 2 | 12 | 5/29/2020 0:00 | 2684 |
| 2 | 13 | 8/19/2014 0:00 | -1.95 |
| 3 | 14 | 3/27/2020 0:00 | 16632 |
| 3 | 15 | 4/11/2020 0:00 | 22400 |
| 3 | 16 | 5/1/2020 0:00 | 55440 |
| 3 | 17 | 5/2/2020 0:00 | 56000 |
| 3 | 18 | 5/11/2020 0:00 | 56000 |
| 3 | 19 | 1/14/2020 0:00 | -15 |
| 4 | 20 | 4/12/2020 0:00 | 7683.97 |
| 4 | 21 | 4/13/2020 0:00 | -1593.36 |
| 4 | 22 | 4/14/2020 0:00 | 4850.7 |
| 4 | 23 | 4/17/2020 0:00 | 45142.21 |
| 4 | 24 | 4/17/2020 0:00 | 3440.75 |
| 4 | 25 | 4/18/2020 0:00 | 54753.19 |
| 4 | 26 | 4/19/2020 0:00 | 9401.93 |
| 4 | 27 | 4/20/2020 0:00 | 82971.9 |
| 4 | 28 | 4/21/2020 0:00 | -1126.17 |
| 4 | 29 | 4/26/2020 0:00 | 11.84 |
| 4 | 30 | 4/28/2020 0:00 | 4030.56 |
| 4 | 31 | 5/5/2020 0:00 | 158.4 |
| 4 | 32 | 5/5/2020 0:00 | 1546 |
| 4 | 33 | 5/5/2020 0:00 | 9252.28 |
| 4 | 34 | 5/8/2020 0:00 | 6212.08 |
| 4 | 35 | 5/10/2020 0:00 | 13943.39 |
| 5 | 36 | 3/12/2020 0:00 | -3533.53 |
| 5 | 37 | 3/16/2020 0:00 | 781.7 |
| 5 | 38 | 3/17/2020 0:00 | 4070.39 |
| 5 | 39 | 3/17/2020 0:00 | -1130.82 |
| 5 | 40 | 3/18/2020 0:00 | -2533.9 |
| 5 | 41 | 3/20/2020 0:00 | 90171.42 |
| 5 | 42 | 3/21/2020 0:00 | 112326.98 |
| 5 | 43 | 3/25/2020 0:00 | -769.92 |
| 5 | 44 | 3/27/2020 0:00 | 2954.85 |
| 5 | 45 | 3/27/2020 0:00 | 33429.51 |
| 5 | 46 | 3/27/2020 0:00 | 493.61 |
| 5 | 47 | 3/28/2020 0:00 | 10692.06 |
| 5 | 48 | 3/30/2020 0:00 | 16.04 |
| 5 | 49 | 3/30/2020 0:00 | 311.7 |
| 5 | 50 | 3/31/2020 0:00 | 5216.5 |
| 5 | 51 | 3/31/2020 0:00 | 46945.86 |
| 5 | 52 | 4/3/2020 0:00 | 12234.82 |
| 5 | 53 | 4/4/2020 0:00 | 15173.14 |
| 5 | 54 | 4/7/2020 0:00 | -1005.14 |
| 5 | 55 | 4/7/2020 0:00 | 68942.46 |
| 5 | 56 | 4/7/2020 0:00 | 164.54 |
| 5 | 57 | 4/8/2020 0:00 | -1745.8 |
| 5 | 58 | 4/10/2020 0:00 | 9337.78 |
| 5 | 59 | 4/12/2020 0:00 | 2588.26 |
| 5 | 60 | 4/14/2020 0:00 | 3941.09 |
| 5 | 61 | 4/14/2020 0:00 | 40498.88 |
| 5 | 62 | 4/17/2020 0:00 | 3440.75 |
| 5 | 63 | 4/18/2020 0:00 | 1329.17 |
| 5 | 64 | 4/18/2020 0:00 | 40490.79 |
| 5 | 65 | 4/20/2020 0:00 | 13043.65 |
| 5 | 66 | 4/20/2020 0:00 | 104538.49 |
| 5 | 67 | 4/21/2020 0:00 | -1076.44 |
| 5 | 68 | 4/26/2020 0:00 | 5.92 |
| 5 | 69 | 4/28/2020 0:00 | 9590.94 |
| 5 | 70 | 5/5/2020 0:00 | 3175.5 |
| 5 | 71 | 5/5/2020 0:00 | 1236.8 |
| 5 | 72 | 5/5/2020 0:00 | 27922.36 |
| 5 | 73 | 5/8/2020 0:00 | 9025.72 |
| 5 | 74 | 5/10/2020 0:00 | 3555.63 |
| 5 | 75 | 5/12/2020 0:00 | 4564.9 |
| 5 | 76 | 5/12/2020 0:00 | 25639.16 |
| 5 | 77 | 5/17/2020 0:00 | 2782 |
| 5 | 78 | 5/18/2020 0:00 | 5166.9 |
| 5 | 79 | 5/18/2020 0:00 | 97053.84 |
| 5 | 80 | 5/18/2020 0:00 | 6496.2 |
| 5 | 81 | 5/19/2020 0:00 | 4330.8 |
| 5 | 82 | 5/19/2020 0:00 | 54438.42 |
| 5 | 83 | 5/23/2020 0:00 | 4837.5 |
| 5 | 84 | 5/29/2020 0:00 | 158.4 |
Community ChampionHi Anonymous ,
Check this file as an example: Download PBIX
I hope it helps.
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
Thanks a lot by your Help Ricardo, I review your PBIX and I will tell you if your recommendation resolve my issue.
Regards
Robert
v-xuding-msftCommunity Support
Hi Anonymous ,
I have tested the pbix file that camargos88 did. It should work. If it works for you, please accept the helpful answer as a solution. If you still have questions, please share the expected results. Then we will understand clearly.😉