Functions if + and

[Anonymous]

Hello everyone,

Could you help me?

With the data set below I want to create a "dta prov 2" that returns me a date, in the format mm/yyyy, corresponding to the month and year that results from the billdate + 210 days (7 months) . This is the information I have in "Dta Prov" (Dta Provisão = IF(MONTH('Facturas GCobros'[billdate].[Date]) < MONTH( TODAY()); FORMAT(DATEADD('Facturas GCobros'[billdate].[Date];210;DAY);"mm/yyyy");BLANK() & IF(YEAR('Facturas GCobros'[billdate].[Date]) < YEAR( TODAY()); FORMAT(DATEADD('Facturas GCobros'[billdate].[Date];210;DAY);"mm/yyyy"); BLANK())).

But, beside this, I want this new column to consider also all the invoces that has  "Pending" =  0, regardless of the previous permiss.

So, if DTA PROVISAO = mm/yyyy (today) & PENDING = 0, then "dta prov 2" = mm/yyyy (today)

Name	Invoice	Pending	Provision	Billdate	Dta Provisao
ipsum	53101609	0,00	738,00	31/07/2005	01/2006
lorem	63101733	0,00	2.586,00	30/06/2005	01/2006
alfa	11145483	18.625,00	0,00	31/05/2018	12/2018
beta	11145728	0,00	3.895,00	31/05/2018	12/2018
omega	11146886	4.207,00	0,00	31/07/2018	02/2019
charlie	11147044	0,00	6.000,00	31/07/2018	02/2019
gamma	11147697	500,00	0,00	30/09/2018	04/2019
delta	11147698	4.000,00	0,00	30/09/2018	04/2019

I've been struggling with the "IF's" and "AND's", but with no results, so far...if someone has any idea, i would appreciate!

Thank you,

Irene

[HotChilli]

dta2 = VAR _today = FORMAT(TODAY(), "MM/YYYY")  
RETURN
IF (AND( FORMAT(Table4[Dta Provisao], "MM/YYYY") = _today, Table4[Pending] = 0.00), _today)

Try this