Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Table 1 has ID and a date, and in this table I want to add a calculated column.
Table 2 is a child of table 1 (FK is table1.ID), has its own ID and has a text column.
The calculated column is to be TRUE or FALSE according to the value of table1.date (>= 01/10/2021 & <= 30/11/2021) AND whether table2.text has values of "VALUE A" OR "VALUE B".
I've tried IF with LOOKUPVALUE etc... and get the (expected) "A table of multiple values was supplied where a single value was expected" error.
I cannot fathom which DAX function to use for this...
Solved! Go to Solution.
@RichHead1821 , If you need a new column in table A
New column =
var _cnt = countx(filter(TableB, TableB[value] in {"VALUE A" , "VALUE B"}), [Value]) +0
return
if(_cnt >0 && Table1[Date] >= date(2021,10,01) && Table1[Date] <= date(2021,11,30), true(), false() )
Perfect, thank you sir, also able to follow and understand.
@RichHead1821 , If you need a new column in table A
New column =
var _cnt = countx(filter(TableB, TableB[value] in {"VALUE A" , "VALUE B"}), [Value]) +0
return
if(_cnt >0 && Table1[Date] >= date(2021,10,01) && Table1[Date] <= date(2021,11,30), true(), false() )
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |