Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic flag based on date granularity

Hello everyone,   I have the table (example) below, it contains dates of orders, email of the client and a “New Customer Flag” (nc_flag with 1 as new customer NC and 0 as returning RC) (this flag h...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous

     

    You can create a measure as a second flag to filter email accounts.

    Flag Measure = 
var maxNCFlag = MAX('Table'[nc_flag])
return
if(maxNCFlag=1,1,0)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous

 

You can create a measure as a second flag to filter email accounts.

Flag Measure = 
var maxNCFlag = MAX('Table'[nc_flag])
return
if(maxNCFlag=1,1,0)

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.