Forum Discussion

RashmitaR's avatar
RashmitaR
Icon for Helper IV rankHelper IV
10 years ago

Dax Query

Hi could anyone suggest me a way to obtain this . Need to obtain headcount of the releases expected in the next three months (ex : If i select feb 2016 in my filter i must obtain data for march-16 , april-16 and may-16) .
Need Help

11 Replies

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    Hi

     

    Can please give little bit clarity .

     

    Based on my understanding , if select Mar 16 in filter u want next three month data in report ?

      • Eric_Zhang's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        RashmitaR

         

        Your requirement is still not clear for me. If you‘d like to get the resignation headcount in the next 3 months of each month, you can reference the attached pbix.

         

  • walnei's avatar
    walnei
    Icon for Helper III rankHelper III
    10 years ago

     

    Hello Friend.


    You can create an auxiliary table and make a relationship to make this filter as image

     

     

     

     

     

     

     

     

     

     

    #PowerBI Seeking Leadership
    Brazilian hug
    IF YOU ARE RIGHT, MARK AS ANSWER TO GUIDE TO OTHER

    • Baskar's avatar
      Baskar
      Icon for Resident Rockstar rankResident Rockstar
      10 years ago

      Hi walnei

       

      1. we can do what u mention , my question is if i want another 6 month ? have to do change again right ?

      2. i didn't get you , how u going to give relationship between these tables ? , bec the basic relationship in cardinality column should have one unique value right ? then how can u....