How to user enter a date for separate columns in base a specific date: before, month, future

[Anonymous]

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

[camargos88 · Accepted 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

[camargos88]

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

[Anonymous]

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 · Accepted 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

[Anonymous]

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-msft · Accepted solution]

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.😉