Forum Discussion
Multiple fact tables
Hi All, I have two tables: Sales Table (data available from 2023 to date): This contains the following columns: Sales ID Sales Category Created Date Value Close Date Budget Table: Th...
Hi,
There should not be any relationship between budget and sales. Active the inactive relationship. Crate a Category Dim table. Ensure that the calendar table goes to the last date available in the budget table. This measure pattern should work
Rev = sum(Data[Revenue])
YTD rev = calculate([Rev],datesytd(calendar[date],"31/12"))
Hope this helps.