Editable if based on other table value

I have two table

Table A & Table B

TABLE A is like

Date | Customer | Amount
1/4/21. Kiran. 500

TABLE B is (only one Row)

Approvel | Editing| Add|

Pending Yes Yes

I want to a Editable if function in table A if table B editing column is Yes?

Anyone can you please help me for this

Sure. The Editiable_If expression would be:

ANY(Table B[Editing]) = "Yes"

Table B[Editing] - returns a list of Editing column values. Since there is only 1 row it will be a list of 1

The ANY() function selects the first list value and returns it as a proper data type value so you can compare it to your literal value of β€œYes”.

Hope this helps!!

3 Likes