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 in Power BI by asheni
• 120 points
5 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,970 points
24,884 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,970 points
1,028 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,370 points
596 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,216 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,003 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,480 points
29,001 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,370 points
300 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,370 points
238 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,370 points
338 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,370 points
612 views