Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Jerzee
Regular Visitor

DAX/Data Modeling

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

 

4 REPLIES 4
Jerzee
Regular Visitor

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

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
Super User
Super User

@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] )
)

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

lbendlin
Super User
Super User

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...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.