Forum Discussion

Subash2345's avatar
Subash2345
Frequent Visitor
10 months ago
Solved

Power BI Date and Month Table

I have a Fact Table, a date table.now the Fact table has got monthly data for different service units and so I am creating a monthly table like this 

Date_Monthly =
FILTER (
    'RPT DimDate',
    'RPT DimDate'[Date] = 'RPT DimDate'[FirstDateofMonth]
)  and connect the Dates of the DimDate and Date_Monthly 1:1 both direction and connect the Fact table to Date_Monthly with Month and Year many to one single direction. 
My question is -  Can I have these two tables in my moble, given the fact that I have marked RPT DimDate as my date table?
Secondly, I am trying to do a Financial Year selection to display values from starting year to the selected financial year- this works only when I have that Date_Monthly in place - Can someone explain?
 
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    10 months ago

    Hello Subash2345 

    Short Recommendation

    Yes, you can have both 'RPT DimDate' (daily) and 'Date_Monthly' (monthly) tables in your model.

    But only one table (the daily 'RPT DimDate') should be marked as the official Date Table in Power BI.

    The 'Date_Monthly' table is fine to keep — just treat it as a helper table for monthly aggregations or fiscal logic.

     


    If my response helped you, please consider clicking
    Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn

     

1 Reply

  • pankajnamekar25's avatar
    pankajnamekar25
    Icon for Super User rankSuper User
    10 months ago

    Hello Subash2345 

    Short Recommendation

    Yes, you can have both 'RPT DimDate' (daily) and 'Date_Monthly' (monthly) tables in your model.

    But only one table (the daily 'RPT DimDate') should be marked as the official Date Table in Power BI.

    The 'Date_Monthly' table is fine to keep — just treat it as a helper table for monthly aggregations or fiscal logic.

     


    If my response helped you, please consider clicking
    Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.


    Thanks,


    Connect with me on:

    LinkedIn