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
I'm trying to add a date range filter to my report page based on Created Date. However, the Created Date filter should only apply to Record Type = "B" and return all records where Record Type = "A". So if I selected a Created Date range of 5/1/2023 - 5/3/2023 it would display Record ID's 1, 2, 4, and 5. Any help to implement this would be greatly appreciated!
Record ID | Created Date | Record Type |
1 | 3/1/2023 | A |
2 | 3/1/2023 | A |
3 | 4/5/2023 | B |
4 | 5/3/2023 | B |
5 | 5/3/2023 | B |
Thank you for the reply. Your solution makes sense but I'd like to display a table that contains all columns, not just a card with the measure.
you may use this code for further calculations:
VAR _table =
UNION(
CALCULATETABLE(
VALUES(data[Record ID]),
ALL(data[Created Date]),
data[Record Type]="A" ),
CALCULATETABLE(
VALUES(data[Record ID]),
data[Record Type]="B"
)
)
for example, tried to verify like:
Measure =
VAR _table =
UNION(
CALCULATETABLE(
VALUES(data[Record ID]),
ALL(data[Created Date]),
data[Record Type]="A" ),
CALCULATETABLE(
VALUES(data[Record ID]),
data[Record Type]="B"
)
)
RETURN
CONCATENATEX(_table, data[Record ID], ", ")
it worked like:
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |