Is there a DAX function that will allow me to see if a value does not show up in a future period?

[Anonymous]

Hi All,

Hope someone can give me guidance on this Power BI problem I'm having. I need to be keep track of all increases and decreases in account support each month. Part of this is being able to see if a value appears in the succeeding month.

I have a table that looks like below:

Activity Month	Employee ID	Client Name	EIDClientName	Employee Count	In Succeeding Month?
Jul-21	John Doe	ABC	John DoeABC	1	No
Sep-21	John Doe	ABC	John DoeABC	1	Yes
Oct-21	John Doe	ABC	John DoeABC	1	No
Jul-21	John Doe	XYZ	John DoeXYZ	1	Yes
Aug-21	John Doe	XYZ	John DoeXYZ	1	Yes
Sep-21	John Doe	XYZ	John DoeXYZ	1	Yes
Oct-21	John Doe	XYZ	John DoeXYZ	1	Yes
Nov-21	John Doe	XYZ	John DoeXYZ	1	N/A

Is there a DAX function that will allow me to get the results similar to the 'In Succeeding Month?' column?

N/A in November is because the latest report date is Nov-2021 so there is no future month to refer to.

Thanks,
E

[Anonymous]

I'm relatively new to Power BI and this problem has been racking my brain for the past few days. So your formula is such an immense help to me. Thank you!!!

[Aburar_123 · Accepted solution]

Hi @Anonymous ,

Please find the below solution,

// Calculated column

Available_in_Succeeding_month =

var is_exists = COUNTROWS(FILTER(ALL('Table'),'Table'[Client Name]=EARLIER('Table'[Client Name]) && DATEDIFF(EARLIER('Table'[Activity Date]),'Table'[Activity Date],MONTH)=1))

return IF(is_exists=1,"Yes","No")

Please like and mark my Post as a solution if it meets your expectation. Thank you.