Forum Discussion

RashmitaR's avatar
RashmitaR
Helper 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
    Resident 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 ?

  • walnei's avatar
    walnei
    Helper 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
      Resident 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....