Forum Discussion

User232431's avatar
User232431
Helper III
1 year ago
Solved

Relationship between two table not working after calculating Last N months

Hi I am trying to buld relationship between two table for common variable after calculating last N months / N weeks / N years Once i create relationship(With Location,Frequency,Period columns form 2...
  • User232431's avatar
    User232431
    1 year ago

    Thank you , My desired output that i am struggling is , when i select all the 3 slicers from Table "Data" , then the graph should display the values (Because i need to display few other values from "Data" table).

     

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, User232431 

    Sry, my mistake, posted the wrong pbix. You can check the pbix file below to see if it meets your needs.

    Best Regards,
    Yang

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. 
    Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, User232431 

    Just create a blank table(Do not add any data), add your measure below this table and delete other filed(Column1).

     

    Best Regards,
    Yang

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. 
    Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum