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
239 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,910 points
53,075 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,910 points
2,986 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,360 points
1,387 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
2,461 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,030 points
4,013 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,520 points
68,472 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,360 points
730 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,360 points
681 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,360 points
954 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,360 points
1,404 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