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
44 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,870 points
33,502 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,870 points
1,693 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
757 views
0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
1,547 views
0 votes
1 answer

How to add slicer from a different tables?

Hi, Join is normally performed to get ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 33,010 points
3,306 views
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,500 points
40,068 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
354 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
309 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
517 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
684 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP