Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Project Cost

Hi,   I'm trying to get the Project cost dynamically based on Month and Year. Below is the sample data.   Project ID Project Name Start Date End Date Monthly Cost 1 A 01-01-19 31-12...
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous 

     

    Please change the relationship between fact table and employee table and set the cross filter direction is both.

    Result:

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

     

     

serpiva64's avatar
serpiva64
Solution Sage
4 years ago

Hi, 

please provide a sample date with just more then 1 row.

To make what you want you don't need writing Power query or Dax, just create visuals