Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have a Table-Value Function that I want to use as a data source and have it parameterized (even if I have two static parameters). The signature is
SELECT * FROM [dbo].[fnCUSTCLUBPLAN] (
<@PeriodStart, datetime2(7),>
,<@PeriodEnd, datetime2(7),>)
I imported it into Power BI with hardcarded dates and the editor shows it as
= dbo_fnCUSTCLUBPLAN(#datetime(2000, 1, 1, 0, 0, 0), #datetime(2000, 6, 5, 0, 0, 0))
Can anyone point me in the right direction?I have a parameter named "Parameter1" that is a date/time type.
Thanks in advance!
Solved! Go to Solution.
Hi @espo4life ,
You can create 2 query parameters to filter the data based on the date field, please refer the contents in the following links to achieve it.
Working with Parameters in Power BI Desktop
How do I pass parameters to my SQL statement?
Best Regards
Rena
Hi @espo4life ,
You can create 2 query parameters to filter the data based on the date field, please refer the contents in the following links to achieve it.
Working with Parameters in Power BI Desktop
How do I pass parameters to my SQL statement?
Best Regards
Rena
That worked beautifully. Thank you!!
Hey @espo4life ,
this article describes what you are looking for:
Hopefully, this helps to tackle your challenge.
Regards,
Tom
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |