Forum Discussion

mike_viz_lord's avatar
mike_viz_lord
Frequent Visitor
3 years ago

Apply Date Range Filter Based on Condition

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". ...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi mike_viz_lord 

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: