2 Replies Latest reply: Oct 25, 2017 4:46 AM by Varun Prakash Paulraj RSS

    finding maximum or recent completed  quarter

    Neha Pathak

      I have multiple values of quarters in filter pane- FY17 Q1 , FY17 Q2 , FY17 Q3, FY17 Q4 , FY18 Q1 , FY18 Q2

       

      I want to create 2 measures to find out the count of employee id of  recent completed quarter i.e. FY18 Q2  in one measure

      and count of employee id of  previous completed quarter i.e. FY18 Q1  in second measure