Two Filters

[HenryJS]

Hi all,

How do I filter the data below data to include:

• EITHER PlacementDate is in the last 1 week
• OR PlacementExtensionStartDate is in the last 1 week

When I put both filters on in the filter pan it only shows data which are both Placement Date and Placement ExtensionStartDate is in the last 1 week.

I would like to return data where either Placement Date or Placement ExtensionStartDate is in the last 1 week.

[Anonymous]

Hi

all filters are applied in AND, you can't by design have OR filters (not in a visual like that anyway). That is the way Datawarehouse works (as you're slicing a piece of the cube), not a limitation of PowerBI. 

One workaround is to create a secondary column in your original datasource where you store the "max" of (PlacementDate, PlacementExtensionDate), then your filter works on this column rather than the original two. It has some drawbacks but is the easiest and quickest.

[HenryJS]

Hi all,

Please could someone help me with the below DAX?

Starters = IF(('Placements - (candidates)'[PlacementDate] = LAST 7 DAYS ) && ('Placements - (candidates)'[ExtensionEndDate] = LAST 7 DAYS ),1,0)

I don't know how to write the last 7 days part of expression.

Thanks,

Henry

[v-gizhi-msft]

Hi,

Please try to use relative date filtering:

Hope this helps.

Best Regards,

Giotto Zhi

[Anonymous]

Starters = IF(('Placements - (candidates)'[PlacementDate] >= TODAY()-7 ) && ('Placements - (candidates)'[ExtensionEndDate] = TODAY()-7),1,0)

[Greg_Deckler]

You will most likely need to create a measure that returns something like 1 given your criteria and BLANK otherwise and add that to your table. Then you could filter on that.