I have need to link 2 table date field stuck at relationship

[Paulyeo11]

Hi All

Hope some one can advise 

After click 2 drop down box  , still cannot press ok :-

[amitchandak]

@Paulyeo11 , As per the message you already have a relation between these two columns . First, delete the existing one. If you want to create again.

[Paulyeo11]

Hi Amit

Kindly help me take a look of my PBI file :-

https://www.dropbox.com/s/mflp2df9id8bmjm/SI_PM_V001%20Final%20Amit.pbix?dl=0

How to make the Sales amount link to master calendar = 3977

[Ashish_Mathur · Accepted solution]

Hi,

Download the PBI file from here.

Hope this helps.

[Paulyeo11]

Hi Ashih

I try to link again  but it still cannot get the correct value , can you share with me what you did ? When i add Price field to the table , Date field value all missing.

[Ashish_Mathur]

Hi,

Your Date Table should be from 2003.

[Paulyeo11]

Hi Sir

I just notice that date is wrong , may i know how to adjust ?

[Ashish_Mathur]

The formula for the Year should be =year(date[date])

[Paulyeo11]

Hi Sir

it is not due to Year expression , as i have below 2 file one is working fine another one is not working ;-

I have below file is working fine 😞 This file is Ash help to link the raw data table to master calendar )

https://www.dropbox.com/s/4u3hnura2x2c4i4/preWebinarPostCal_PY_DATA%20V008%20Working.pbix?dl=0

I have below file is not working :-( This file from Mr Amit and i add my own raw data )

https://www.dropbox.com/s/5pqxtqpx4fb93fq/SI_CSV_v005%20Not%20Working.pbix?dl=0

Paul

[Ashish_Mathur]

Hi,

In the Date Table, the formulas in the Date and Year columns should be

Date = CALENDAR(Date(2003,01,01),date(2020,12,31))

Year = year('Date'[Date])+0

Format the Year column as Whole number.

Hope this helps.

[Paulyeo11]

Hi Sir

Thank you for your sharing . I already change but still the same :-

https://www.dropbox.com/s/xgb0k0swewei1lf/SI_CSV_v005%20Not%20Working%20Final.pbix?dl=0

Paul

[Ashish_Mathur]

Someone else will help you then.

[Paulyeo11]

Hi Amit ( edit it should Ash )

May i know where i go wrong ?

Paul