Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Retrieve results set based on user input date. if date not available pick the most recent one.

Hi,    I have a requirement to receive a single date or date range as a input from the user and filter my record set to display in report.  Some thing similar to how we handle parameters in SSRS re...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks Cherie for your reply.  I am planning to have SSIS to do this job to create dataset and later consume in power BI. 

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

 

Correct.I would suggest you use measure to get the dynamic date from columns when user selects a date.Here is the post for your reference.

 

Regards,

Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Cherie for your reply.  I am planning to have SSIS to do this job to create dataset and later consume in power BI. 

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous 

     

    Got it, if you have resolved the issue, please mark the right reply as answer, and welcome to share your own solution. More people will benefit from here.

     

    Regards,

    Cherie