User Profile
Learn001
Regular Visitor
Joined 1 year ago
User Widgets
Contributions
year to date plus 3 month future year sales target data
hello, i need help i have 3 column of data: date whole yearof 2023,2024 and some of data 2025, and another of actual sales and the target sales data, have the Year Slicer and a line and cluster column chart, have dax to show the actual sales data using: Sales YtD = calculate(sum('SALE'),year('DATE')) and how can i do for TARGET to show Year to Date data plus 3 month of future year? so in the chart i have data of a whole year to date 'TARGET' and 'SALE' data and see +3 month of 'TARGET' data? of course 'SALE' still blank for this future 3 month. like this if in excel:
