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!!
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |