Forum Discussion
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
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 followsOrder Amount = CALCULATE ( [Sales Amount], DATESYTD ( 'Date'[Date] ) ) ----------------------------------------------- Due Amount = CALCULATE ( [Sales Amount], USERELATIONSHIP ( fact[due Date], 'Date'[Date] ), DATESYTD ( 'Date'[Date] ) )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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Thank 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=14Second 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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
