Forum Discussion

anileshknpowerb's avatar
anileshknpowerb
Helper III
6 years ago

Reference vs Duplicate vs Calculated Table

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 t...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
6 years ago

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.

anileshknpowerb's avatar
anileshknpowerb
Helper III
6 years ago

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?

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    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.