Forum Discussion
Problem with Combined Database and Excel data
Good Morning, I have accumulated data, which are obtained from a database and an Excel file. The comparison of the last years should be shown. Everything works fine, except for the year 2020. Ther...
Marcus_S , If you have date then use date table to join with date then try a measure like.
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))