Create a variable to act as a filter within calculate

Hi Reigning_data 

• Does your Period table need to respond to filter context in any way?
  If so, then you can't currently do what you've described in a model built in Power BI Desktop. However, you can do this sort of thing Azure Analysis Services, this should eventually be possible in Power BI.
  See these articles on DETAILROWS and Calculation Groups:
  
  • https://www.sqlbi.com/articles/creating-table-functions-in-dax-using-detailrows/
  • https://www.sqlbi.com/blog/marco/2019/03/01/calculation-groups-in-dax-first-impressions/
  • https://blogs.msdn.microsoft.com/analysisservices/2019/03/01/whats-new-for-sql-server-2019-analysis-services-ctp-2-3/
• If your Period table doesn't need to respond to filter context (e.g. if it's always a fixed date range), then you could use this workaround:
  1. Create a DAX calculated table called Period using the expression such as in your original post using DATESBETWEEN or some other method.
  2. Since the Period calculated table won't retain lineage, you can use TREATAS to apply the Period table as a date filter within measures, for example:
     

     Revenue =
     CALCULATE(
         SUM ( column1 ),
         TREATAS ( Period, 'Date'[Date] )
     )

Regards,

Owen