Forum Discussion
Helper VRelationship between Calendar Dimension and Facts Table
Community Championtwister8889 - It doesn't really work that way. You could create a new date table from your dates in Fact table like this:
Calendar 2 = CALENDAR(MIN('Fact'[Date]),MAX('Fact'[Date]))
twister8889First of all, thank you for your answer..
amitchandak ok, thank you
Greg_Deckler But I will have another fact tables with other dates, I can create a new calendar date by multiples facts tables?It's an It's a possibility to filter or join calendar table with facts tables?
- Greg_Deckler
twister8889 - What is your concern with having a date table with more dates than in your fact table? This is an extremely common scenario.
- twister8889
Hello,
I'm sorry for the delay, my concern is when the user filters the date or when I use the month in the chart as a dimension, I don't want to show all dates from the calendar dimension, I would like to show only the dates existing in the facts tables in the filter and the charts as a dimension
After I did the link between the Fact and calendar table, I imagine using the field Column of dcalendar table as a dimension in my charts and filters correct? However, now I have the wrong result because it is showing dates that I don't have in my fact table.
I already did this, I created a column called Column, to link with the Month field in Fact Table. The Column has the same format, 01/MM/YYYY