Forum Discussion

sieed's avatar
sieed
Icon for Helper II rankHelper II
9 years ago
Solved

Creating 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 ...
Need Help
  • rocky09's avatar
    rocky09
    9 years ago

  • sieed's avatar
    sieed
    9 years ago

sieed's avatar
sieed
Icon for Helper II rankHelper II
9 years ago

LaurentCouartou, I have created a Date Table with the past fifteen dates. Question is, how do I join it with my current table? There isno common field between the two...  nI can share my pbix file but I dont know how to attach it. 

rocky09's avatar
rocky09
Icon for Solution Sage rankSolution Sage
9 years ago

date is the common field in both tables. you can create link.

  • sieed's avatar
    sieed
    Icon for Helper II rankHelper II
    9 years ago

    rocky09,  the Date table contains a bunch of dates. There is no JobID. So, can't connect it. 

    • rocky09's avatar
      rocky09
      Icon for Solution Sage rankSolution Sage
      9 years ago

      • sieed's avatar
        sieed
        Icon for Helper II rankHelper II
        9 years ago