Forum Discussion
fact table startdate -enddate
hi cv02011
You could create a measure as below:
Measure =
CALCULATE (
MAX ( Table1[Category] ),
FILTER (
Table1,
Table1[Product] = SELECTEDVALUE ( Table2[Product] )
&& SELECTEDVALUE ( Table2[Date] ) >= Table1[StartDate]
&& SELECTEDVALUE ( Table2[Date] ) <= Table1[EndDate]
)
)Result:
and here is sample pbix file, please try it.
Regards,
Lin
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
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/38490Regards,
Lin
