DATE FUNCTIONALITY and FILTER

[TheBIguy]

Hello All,

Hope you all doing well.

I have two columns one runs with regular date while another one has month end date now I have to do filteration on these dates." DD/MM/YYYY Format"

EVENT_DATE	RATE_DATE
1/7/2021	31/01/2021
2/7/2021	28/02/2021
3/7/2021	31/03/2021
4/7/2021	30/05/2021
5/7/2021	30/06/2021

I have to create 4 filters

Daily
1. So the user will enter a date through action filter on Daily Date ex 20/07/2021 now the first filter is daily so need data for previous day from this date i.e 19/07/2021

MTD

2 Now the Date is fixed i.e 20/07/2021 so the date should pick up from last month end date from End_Date i.e 30/06/2021

QTD

3.as date is 20/07/2021 the last quarter end date would be 30/06/2021 from End_Date

YTD

4. as date is 20/07/2021 the YTD would be 31/12/2020 from End_Date

Help with this people I know we can get this!

Kind Regards!

[TheBIguy]

Hello All,

Need a quick help. I really got confused in picking values in a table

I have this table where P has acquired Q for 2000.00

Table 1

a	b	c
P	Q	2000
R	S	3000

Master table

a	d	e	f	g	h
P	1	2	3	4	5
Q	1	2	3	4	5
R	1	2	3	4	5
S	1	2	3	4	5

Expected O/P

Master Table

a	c	d	e	f	g	h
P	2000	1	2	3	4	5
Q	-2000	1	2	3	4	5
R	3000	1	2	3	4	5
S	-3000	1	2	3	4	5

Please help

Regards!