How to connect DimDate table to fact and dimensional tables

0 votes

Hi,

I have fact table,Dim project , Dim student & Dim date tables in the power BI model.

  • Fact contains studentid,projectid,is submitted, submitted date ,marks
  • Dim student contains studentid,joining date, name
  • Dim project contains projectid, project creation date, project type

As the requirement I want to showcase following points in one dashboard.

  1. Marks based on student joining date
  2. Marks based on project creation date
  3. Marks based on submitted date

Using one year & month filter using  Dim Date table. Following is the power bi model that I created ,

So as this,Dim student & dim date / Dim project & dim date relationship is not active.

How I solve this in order to answer above requirements? Is this power bi model is correct or not?

Looking for a reply.Thanks in advance.

  

Nov 20, 2021 in Power BI by asheni
• 120 points
380 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Power BI

0 votes
3 answers

How to create final table based on Joins of two tables in power BI?

To do so, follow these steps: From the ...READ MORE

answered Dec 16, 2020 in Power BI by Gitika
• 65,770 points
56,071 views
0 votes
1 answer

I have a web API with basic authorisation and username and password. How do i connect to it in Power BI?

Hey, @There, I found your query is quite ...READ MORE

answered Oct 29, 2020 in Power BI by Gitika
• 65,770 points
3,627 views
+1 vote
1 answer

How to perform aggregate and add in power bi table?

In Power BI, solutions for measures such ...READ MORE

answered Oct 29 in Power BI by pooja
• 8,470 points
73 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
1,669 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
1,069 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
905 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
1,259 views
+7 votes
4 answers

What is Business Intelligence

Business In Intelligence is a set of ...READ MORE

answered Oct 10, 2018 in Power BI by Kalgi
• 52,350 points
1,718 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP