How to monitor payment based on specific date

[ikasukuri]

Hi All,

I'm still new using Power BI. I would like to know whether we can monitor payment based on specific date.

For example.

I need pay to ANGKATAN KOPERASI KEBANGSAAN MALAYSIA BERHAD before/on 6th every month

while for LEMBAGA TABUNG HAJI before/on 10th every month.

I wolud like to create chart which i can see due date before the datelines. (5 days before and 3 days before) calculate based on working days.

Thank you

KOD	JABATAN/AGENSI	GROUP	CARA BAYARAN (EFT/CEK)	DUE DATE EACH MONTH
G-B-A265	ANGKATAN KOPERASI KEBANGSAAN MALAYSIA BERHAD	JABATAN/AGENSI LUAR	EFT	6
G-B-L064	LEMBAGA TABUNG HAJI	JABATAN/AGENSI LUAR	EFT	10
G-B-K132	KETUA PENGARAH HASIL DALAM NEGERI	JABATAN/AGENSI LUAR	FPX	15
G-B-K131	KUMPULAN WANG SIMPANAN PEKERJA	JABATAN/AGENSI LUAR	DDA	15
G-B-S318	SOCSO	JABATAN/AGENSI LUAR	FPX	15
B-B-L098	LEMBAGA ZAKAT SELANGOR	JABATAN/AGENSI LUAR	EFT	10