This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
i need to write the m code
my requirement is, i need to create parameters for start year and end year, start month and end month,start week and end week, start date and end date.
if user has selected start week and end week, and not selected year, month and date filter. it automatically take current week of the year. if user has selcte june month not slected other parameters it should take current month of year(june, 2022). Please help how to to write the code.
i have attached scrrenshots which i have created for week. I have start week and end week parameter. and passed parameter to direct query(query). After publishing the report in service, I can change paramters dynamically. like i need for year and month and date should include all four (year, month, week, date) be there If i select only start month and end month parameter only and user havn't selected anything. it should automatically take current year month) . iam not able attach sample file.so i attcahed screenshot.
Kindly help to write accordingly.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |