Forum Discussion

PradipMCT's avatar
PradipMCT
Icon for Resolver II rankResolver II
2 years ago

Creating a relationship in Powerbi

Hi everyone, I'm working on a Power BI model to analyze training costs and compare them to allocated budgets. I have data in separate tables for: Employee Master Training MIS (Management Informat...
Need Help
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi PradipMCT 

Your exisitng data model looks good.
Yes, you can Add location DIM table and connected with other table to analyse the data.
YTD Calculation - https://learn.microsoft.com/en-us/dax/totalytd-function-dax

https://dax.guide/datesytd/#:~:text=In%20order%20to%20use%20any,the%20days%20in%20this%20range.

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin