Forum Discussion

Dimitris_Kats's avatar
Dimitris_Kats
Helper V
2 years ago
Solved

Modeling - consolidated tables

Hello dear members I would like a confirmation regarding my logic behind a data model. I have one fact table with data from a hospital with all the illnesses and the average cost of them. So for ex...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Dimitris_Kats 

    For better data model, please create a DIM table for Illness and connect with both Fact table
    You can enter data for DIM table directly in Power BI desktop or Power Query editor
    Or usa DAX =  DISTINCT(Table2[illnesscolumn]) to create the DIM table



    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 LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi Dimitris_Kats 

For better data model, please create a DIM table for Illness and connect with both Fact table
You can enter data for DIM table directly in Power BI desktop or Power Query editor
Or usa DAX =  DISTINCT(Table2[illnesscolumn]) to create the DIM table



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 LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin