Forum Discussion

JAVED's avatar
JAVED
Icon for Helper I rankHelper I
8 years ago
Solved

Filtering

Hi  I have a 3 column with Consumed ,Date,Product Name Now based on last 6 months i need to divide the product column in to 3 one should show only first 50 Products consumed on the last 6 months ne...
APIS and Embedding
Content Packs
Custom Visuals
Data Modeling
Gateways
Mobile
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi JAVED,

     

    You can create calculated columns below: 

     

    0-50 = IF(DATEDIFF('Table1'[Date],MAX('Table1'[Date]),DAY)<=50,Table1[Price],BLANK())

     

    50-150 = IF(DATEDIFF('Table1'[Date],MAX('Table1'[Date]),DAY)<=150 && DATEDIFF('Table1'[Date],MAX('Table1'[Date]),DAY)>50,Table1[Price],BLANK())

     

    >150 = IF(DATEDIFF('Table1'[Date],MAX('Table1'[Date]),DAY)>150,Table1[Price],BLANK())

     

     

    Best Regards,
    Qiuyun Yu 

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi JAVED,

 

Would you please share some sample data and clarify corresponding desired results? 

 

Best Regards,
Qiuyun Yu