Forum Discussion

romovaro's avatar
romovaro
Responsive Resident
4 years ago

Current performance vs Monthly target

HI all   I want to compare current performance versus monthly target. I created some tables but I have issues (,maybe relationships...or better way to do it?)   I have information regarding month...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi romovaro ,

 

For the information you provided, the problem is most likely the direction of the relationships or the cardinality of the relationships.

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs

Have you tried connecting the tables through the calendar table?

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • romovaro's avatar
    romovaro
    Responsive Resident
    4 years ago

    HI Stephen

     

    I will check the link. I have tried the calendar table too.

    Any other idea on how to add the monthly targets?

     

    thanks