Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Query parameters filter another column

hello everyone,   i have a transaction table which has transaction ID, transaction date, account date and some other fields. what i need to do is create two query parameter on transaction date  [s...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

You may create a measure like below.Then use it in visual level filter.Attached sample file for your reference.

Measure = 
VAR E_account_date =
    ENDOFMONTH ( Table1[account date] )
VAR E_start_date =
    ENDOFMONTH ( 'Start date'[Start Date] )
VAR E_end_date =
    ENDOFMONTH ( 'End date'[End Date] )
RETURN
    IF (
        MAX ( Table1[transaction date] ) >= MAX ( 'Start date'[Start Date] )
            && MAX ( Table1[transaction date] ) <= MAX ( 'End date'[End Date] ),
        IF (
            MAX ( Table1[account date] ) = E_account_date
                && MAX ( Table1[account date] ) >= E_start_date
                && MAX ( Table1[account date] ) <= E_end_date,
            1
        )
    )

Regards,