DAX/Data Modeling

[Jerzee]

Greetings Folks,

I am in need of assitance with your expertise. For a time intelligence calculation, i have a fact table and a dimension table. I need to use the "Fullalternatedatekey"from the dimension table & the "Sales amount" from the fact table to execute the calculation of "sales ytd" normally id connect "Due date key" & "Order date" i know you can make a copy of a table to connect more keys but im not sure how if i specifically need to use the "Sales amount" they both have to be keys. 

Thank you,

-Jerzee

[Jerzee]

Thank you smart gentlemen, here is the actual visual for better reference. I am only 7 months in my coursera so i do

appreciate both patience. @Fowmy & @lbendlin 

its from "Radacad" and he does not use the "Userelationship" function. That is where i am stuck. He only uses "DatesYTD" function. See below. 

Time Intelligence->
https://www.youtube.com/watch?v=x4KBv-GNohY&list=PLolyY2hNGRKb0EK8NoLZOnzt1aAQBeOGl&index=14

[lbendlin]

Second request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Fowmy]

@Jerzee 

It seems you are trying to use two relationships with  Date Dimension to "Due date key" & "Order date" . You should be able accomplish using USERELATIONSHIP.

Two measures as follows 

Order Amount = CALCULATE ( [Sales Amount], DATESYTD ( 'Date'[Date] ) )

-----------------------------------------------

Due Amount =
CALCULATE (
    [Sales Amount],
    USERELATIONSHIP ( fact[due Date], 'Date'[Date] ),
    DATESYTD ( 'Date'[Date] )
)

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...