Forum Discussion
Line chart challenge
(Edited) Hi, I intend to create a single line chart that visualizes 2 set of values - OValue and Forecast_Value. (both in different tables) The user is given an option to choose a Product ID...
Anonymous , with help from a date table and date from date table is used on axis
Value_A = calculate(sum(Table[Value]), dateadd('Date'[Date],-10,day))
Value_B = calculate(sum(Table[Value]), dateadd('Date'[Date],10,day))
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.