Forum Discussion

cv02011's avatar
cv02011
New Member
6 years ago

fact table startdate -enddate

I have a slowly changing dimension and a Fact Table Product Category StartDate EndDate P1 C1 01/01/2020 20/01/2020 P1 C2 21/01/2020 31/03/2020 P2 C3 01/01/2020 31/12/2099 ...
Need Help
cv02011's avatar
cv02011
New Member
6 years ago

Thank you very much,

but if I have another 2-3 fact table containing product-sales-date and I have to put all informations toghether?

And the dimension doesn't contain only the category, but some attributes also (for example color and so on)--- 

Is it necessary to create a measure for every attribute,including every fact table in the formula?

I don't know the best way to use a slowly changing dimension in a pbix.

 

Thank you 

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  cv02011 

You may need to create the relationship among these tables. please refer to this document:

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

 

If you still have the problem, Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Regards,

Lin