Forum Discussion

frieso's avatar
frieso
Regular Visitor
9 years ago
Solved

How to filter distinct count across multiple dates

Hi everybody   I have a table with a List of opportunities, having dates when the first call of the opportunity took place, when the meeting took place, date of sending the offer, date of receiving...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi frieso,

     

    Assume the source table like below:

     

     

    You can open Query Editor, select columns Calls, Meetings, Offers and Contracts, then click Unpivot Columns button get the format below:

     

     

    Apply the modification, go to the report, create a matrix and slicer visuals.

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi frieso,

 

Assume the source table like below:

 

 

You can open Query Editor, select columns Calls, Meetings, Offers and Contracts, then click Unpivot Columns button get the format below:

 

 

Apply the modification, go to the report, create a matrix and slicer visuals.

 

 

Best Regards,
Qiuyun Yu