Is it possible to display data for last 6 days and future 6 days together

[Anonymous]

Dear All,

I am having a set of data that has data related to past few weeks and some predictions for future weeks.

Is it possible to include the data for both future and the past in the same visual, could be a Matrix, Table or a Column chart.

Thanks

[Kishore_KVN]

Hello @Anonymous You can create a measure to filter data as such and use it in the visual. 

Create a calendar table and connect it with the data table and then the Measure looks like this:

Filtering Data = 
Var L6D = DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-6)
Var N6D = DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+6)
Var Result = CALCULATE(SUM(Data_Table[Sales]),FILTER('Calendar','Calendar'[Date]>=L6D && 'Calendar'[Date]<=N6D))
Return
Result

Output looks as below. First visual for last and next 6 days only. Second visual shows entire data.

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Anonymous]

@Kishore_KVN 

Thank you for your help. Is it possible to make it Weeks instead of days, as the date is displaying the beginning of the week?
Further, I have little confusion here... Measure should be created in Values table right?

If so, then how to add the date and Measure data in the same table?

Sorry for asking very silly questions.

[Anonymous]

@Kishore_KVN , I am stuck at imlementing this solution.

Could you please help/guide me. 

Or could you please share the .pbix file in which you have created, so that I can prepare my file accordingly. 

Thanks

[iceparrot]

Hey @Anonymous , 

I don't know how your data actually looks like but you can create a filter on your data which selects data based on today's date 6 days in the past and 6 days in the future and then use the filtered data for your visuals. 

Can you maybe share some demo data?