Forum Discussion

nmarti13's avatar
nmarti13
Frequent Visitor
8 years ago

DATEADD combined with filter function

Hi there,   I was wondering if anyone could help me. I'm rather new to power bi.   Essentially, I have a dynamic chart which shows how much advertising has been booked for the months ahead. The f...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi nmarti13,

 

Can you share a dummy sample?

It seems you need to consider different dates in different columns at the same time. Maybe you can create many relationships. Only one is active. Then you can use dax/userelationship-function-dax in the formula.

 

Best Regards,

Dale

  • nmarti13's avatar
    nmarti13
    Frequent Visitor
    8 years ago

    Hi Dale,

     

    Thanks so much for your response. Please see the dashboard belolw and the mapping I have done. I have map only one date box that i've only mapped to the budget dates and on sale date. I don't know if I need to edit this in some way, maybe that is the issue? 

     

     

    Thanks,

     

    Natalie 

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi Natalie,

       

      I'm afraid we can't see much from the images. Can you share the pbix file? You can make a DUMMY sample.

       

      Best Regards,

      Dale

      • nmarti13's avatar
        nmarti13
        Frequent Visitor
        8 years ago

        Hi Dale,

         

        Sorry how do I do that as some of the data is confidential?

         

        Thanks,

         

        Natalie