Slicer Date selection act as dynamic joining condition in the query

[Anonymous]

I'm importing a synapse query in Power BI, the query consists of dynamic date joining condition based on user selection in the slicer. How to achieve this functionality in Power BI? Please find the screenshot for the reference:

My requirement is not to hardcode the date condition in query, it should be dynamic, based on what dates user selected on slicer.

Thanks,
MG

[amitchandak]

@Anonymous , You can create measure/s and use that in visual or as a visual level filter

countrows(filter(Table, Table[Invoice Date] >= date(year(Today())-2,1,1) && Table[Invoice Date] <=today()) )

[Anonymous]

Hi Amit,

Thanks for the reply!!

My requirement is related to data source joining condition based on user selection, not related to filtering condition. Means whatever slicer selection the user select in canvas, the sql query in Power Query Editor modifies it is joining condition and return dataset or query output with respect to that slicer selection from the datasource.

Thanks