Forum Discussion
sieed
Helper II
Helper IICreating Custom Date range
I am trying to create a custom date range that shows the last fifteen days no matter if there is data for that date in my table or not. As long as it's in the last 15 days range, it should be shown ...
LaurentCouartou
Solution Supplier
Solution SupplierI assume you do not have a dedicated Date table in your model. If not, add one and link it to your data. (Date tables are meant to solve this kind of problems).
The most basic date table has only one column and contains a set of contiguous dates.
The quickest way to create one would be to add a calculated table to your model and use the CALENDARAUTO() function.
sieedHelper II
Helper IILaurentCouartouSo, do I have to jon this date table with my current table? How exactly does that work?
I have already created the datwe table, but am not sure hwo tojoin it with the job table I have because there is no common field. I can share my pbix file but I am not sure how to attach it.