Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.😉
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 |
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
Thanks a lot by your Help Ricardo, I review your PBIX and I will tell you if your recommendation resolve my issue.
Regards
Robert
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.😉
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
75 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |