View My Drafts
Hi Clark,You should make this work using slicer, no need for parameters. You should use parameters in Power Query if you would like to filter data source data based on users' selection.
But if your goal is to give users option to dynamically change ranges for date opened/closed slicers should do the work.
Create 2 slicers: one for date opened, second for date closed (and make their behaviour "between".
After that create 2 measures:
Hi @Clark Bethancourt,Sorry if my syntax is wrong, but you can use something like this:Count Open =var min_start = ***define min start using MIN() Function***var max_start = ***define max start using MAX() Function***ReturnCALCULATE( COUNTROWS(Table1), Table1[Open Date] >= min_start && Table1[Open Date] <= max_start)Count Close =var min_end = ***define min end using MIN() Function***var max_end = ***define max end using MAX() Function***ReturnCALCULATE( COUNTROWS(Table1), Table1[Close Date] >= min_end && Table1[Close Date] <= max_end)Also here is video from on how to pass on parameters from excel.https://youtu.be/iiNDq2VrZPYI hope this works.Thank you,