DAX Measure if client has bought product A or B la

2019-03-03 07:55发布

I need a DAX measure which shows me a flag (1 or 0) if a customer (DimCustomer) bought the product "A" someday (for the first time) and later (doesn't matter when) have bought or product "B" or "C".

Measure1: Flag (1 or 0) in their customer names if bought

Measure2: When was the first time that they bought product B or C

Basicly I have a FactSales, DimCustomer, DimDate and Dimproduct

Can someone help me?

0条回答
登录 后发表回答