Conditional Formatting for Latest Date Selection

[arun2001mjl]

Hello Team,

In PowerBI, i have loaded 3 files (Table1, Table2 & Table3). All 3 files were related each other.

In Each Table, i have Account Name, Capability, Update Date and Updated by.

I have created a Table Visual in PowerBI and moved the columns as shown in below table.

In Columns, Latest Update(Table1), i have selected the date to show as "Latest", but I did not select "Dont Summarize". I need a conditional Formatting whenever the date is blank or if it is greater than 30 days from Today. I created a new column and used below formula for all 3 tables but it is not working as expected. When we use "Dont summarize", it works. But, when i select to show only "Latest" dates it is not working.

Sample Formula is fyi.

IF(OR(DATEDIFF(Table1[Latest Update(Table1)],Today(),DAY) >30, [Latest Update(Table1)] = BLANK()), 1, 0)

Below Table is sample:

AccountName	Capability	Total Resource	Latest Update(Table1)	Latest Updated By(Table1)	Latest Update(Table2)	Updated By(Table2)	Latest Update(Table3)	Latest Updated By(Table3)	AW update(Table1)	TB update(Table3)
Test1	CBP1	3.0			05/09/22		2/5/2020	User7	0	0
Test1	CPB2	7.0			05/09/22		12/9/2022	User1	0	0
Test1	CBP2	28.0			05/09/22		12/9/2022	User1	0	0
Test1	CPB3				17/05/23	User6			0	0
Test1	CBP3	21.0	12/9/2022	User1	05/09/22		12/9/2022	User1	0	0
Test1	CPB4	16.0	5/11/2023	User2	06/12/22	User5	12/6/2022	User8	1	0
Test1	CBP4	13.0	5/11/2023	User3	05/09/22				1	0
Test1	CPB5	28.0	5/11/2023	User4	05/09/22		5/11/2023	User4	1	1
Test1	CBP5	45.0	5/11/2023	User4	11/05/23	User4	5/11/2023	User4	1	1
Test1	CPB6	9.0	5/11/2023	User2	05/09/22		5/8/2023	User9	1	1
Test1	CBP6	26.0	5/11/2023	User2	05/09/22		12/9/2022	User1	1	0
Test1	CPB7	19.0			05/09/22		5/2/2023	User2	0	1

Please help.

Regards

Arun

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...