Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts,
I have a table SalesFact and I need to join 2 Dates, i,e, ShipDate and OrderDate.
What is the better approach to handle this? And why is the approach is better?
1. Duplicate the Date Dimension in power Query Editor for OrderDate..
2. Create reference of Date Dimension in Power Query Editor for OrderDate.
3. In the modeling Tab, Use the "New table" option like below
NewTable = DimOrderDate
Thanks,
Anilesh
Hi @anileshknpowerb ,
In conclusion, Duplicate is generally used when you would like to create a similar query and you do not want to type the same code. Reference in Query means you would like to use that Query results in some other queries where your original query remains as a base Query and it can be used in other queries for the further processing.
In addition, this viedo and article explain the difference between Duplicate and Reference in details that you can refer:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
use the same date dimension for both dates but one will be inactive and other active, and then you need to use the userelationship() function
https://www.youtube.com/watch?v=sONvctPlplY this video explains well
so just as you would use a role playing dimension in tradition kimball star schema (dont know if that makes sense), you can do the same in power bi, you just need to utilise the above function.
Proud to be a Super User!
I want to show OderDate and ShipDate as separate dates so that users can do adhoc analysis on both dates. In that case, which one I should go with?
Hi @anileshknpowerb ,
If you just want to show it as separate dates, you can use Duplicate to try. To do some analysis, you may use some relationships like @ vanessafvg mentioned previously.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |