Forum Discussion
How to user enter a date for separate columns in base a specific date: before, month, future
Hi, I have a report that contain some colums, we need separate the column Monto Pend in 3 columns:
Amount before: amount a specific date: example 23/04/2020
Amount Month: Amount between 24/04/2020 and 30/04/2020 and,
Pend. Futuro: Amount after 01/05/2020
At the moment I have create 3 calculate column and in each column (before,month,futuro) I enter the date for separete teh columns.
How to make this report dynamics?, how to made that the user select the specfic date and the report show the 3 columns with separate information?.
Regards
Robert
Sample the report
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.😉
5 Replies
camargos88Community Champion
Hi Anonymous ,
The date is dynamic, but the invertal is fixed ?
Date 1 (Before) <= 2020/01/01
Date 2 (Between) between Before + 1 day and Before + 7 days
Date 3 (Future) = >= Before + 7 days
If yes, you can create 3 measures instead of calculated columns. If you need help with that, just give us some data example here.
Ricardo
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 - camargos88
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