Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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...
@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] )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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...
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |