Data Modeling and Correct Linking

[Yrstruly]

How do i get a relationship between payments and invoice, and dates and dates and payments?

see file: https://drive.google.com/file/d/1CBpFLkw37E5aeYSG9RXMLTzOXUCdcn4m/view?usp=sharing

and holidays and payments: https://twitter.com/DataMozart/status/1376164560055508992/photo/1

[Yrstruly]

@Melissa

Is my fact table correect, or should invoice be the fact table?
VijayPHow do i get a relationship between payments and invoice, and dates and dates and payments?

see file: https://drive.google.com/file/d/1CBpFLkw37E5aeYSG9RXMLTzOXUCdcn4m/view?usp=sharing

and holidays and payments: https://twitter.com/DataMozart/status/1376164560055508992/photo/1

[Greg]

Hi @Yrstruly. This forum is for the general education of all members, and we want to encourage the input of all members. By using a single-person callout in your initial post, you are instructing others to not respond to your request.
Greg

[EnterpriseDNA]

Hi @Yrstruly, though we appreciate the detailed information you posted we would like to emphasize that the forum is not an on-demand coaching service.

We encourage participation with everyone. However, as mentioned by @Greg above, we request all users to refrain on singling out anyone to attend to your question as this may discourage other users to help your inquiry.

I also noticed you rephrased your question on a separate thread. We merged the 2 threads for everyone’s convenience. Thanks.

[Melissa]

Hi @Yrstruly,

Go to the Portal and work through Data transformations & Modelling, if you haven’t already.
Pay special attention to the content from this point on OR review that content again.

What are we trying to achieve with the data model?

See the remarks in this post

Need help with model

@Nagi_k, If I were to tackle something like this, here’s the general approach I would take: Before even delving into the data model and the report, I would develop an analysis plan listing the questions I need the report (or far more likely, reports) to be able to address I would then try to arrange these questions into like groups with the idea of trying to bin them into separate reports, each supported by a much simpler data model geared specifically to addressing that subset of questions/…

and also review this video by @Greg .

Data Loading And Transformation - Power BI Best Practices Vol. 1

If you still have questions after that, post an updated/reworked model.
And explain any remaining issues. Thanks!

[EnterpriseDNA]

Hi @Yrstruly, did the response provided by @Melissa help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

[EnterpriseDNA]

Hi @Yrstruly, we’ve noticed that no response has been received from you since the 29th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

[EnterpriseDNA]

Hi @Yrstruly, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!