Forum Discussion
Unable to make Time intelligence calculation work
I have a Sales table (Fact) and a Calender date table, which is marked as the "date table". Both table is linked by the date column in both tables on a 1 to many basis. Calendar table on the 1 side o...
Seems like they should work just fine...Can you post some sample data and the measures you have created?
Anonymous wrote:Seems like they should work just fine...Can you post some sample data and the measures you have created?
Sample View
Sales MTD = TOTALMTD([Sales Total],G_Margin[Date]) - This works but using the fact table date column and not the "Dates"date colmun.
Sales LastMnth = Calculate([Sales Total],PREVIOUSMONTH(Dates[Date])) - Does not return a figure.
Any suggestion?
Thank you