Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
What would be the correct DAX syntax to use based on this example?
There is a slicer in PBI for Selected Period which is filtered to Apr-2019. For the Selected Period in the table below, I need to display this value (as static) for each Reporting Month. The interaction between the slicer and the table is set to none.
Reporting Month | Selected Period |
Jan-2019 | Apr-2019 |
Feb-2019 | Apr-2019 |
Mar-2019 | Apr-2019 |
Apr-2019 | Apr-2019 |
May-2019 | Apr-2019 |
Jun-2019 | Apr-2019 |
Jul-2019 | Apr-2019 |
Aug-2019 | Apr-2019 |
Sep-2019 | Apr-2019 |
Oct-2019 | Apr-2019 |
Nov-2019 | Apr-2019 |
Dec-2019 | Apr-2019 |
My current logic just repeats the respective Reporting Period.
Selected Period =
VAR selectedPeriod = IF ( HASONEVALUE ( 'Reporting Period'[Reporting Month ] ), SELECTEDVALUE ( 'Reporting Period'[Reporting Month] ), 0 ) RETURN selectedPeriod
@rsaphier your report period and selected month are from same table or seperate tables?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
They are from the same table.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 75 | |
| 36 | |
| 31 | |
| 29 | |
| 26 |