Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello
I'm new to Power BI. I have a date slicer with a first date and a second date.
This slicer is not related with the principal table who needs to be filtered.
I made a column " Filtre_cax_1" with this mesure :
Solved! Go to Solution.
@patoku0207 try this:
Filtre_Cas_1 =
var MinDate = FIRSTDATE(Calendrier_SIF[DateSQL]) ' 01/09/2023 in this example
var MaxDate = LASTDATE(Calendrier_SIF[DateSQL]) ' 30/09/2023 in this example
RETURN
IF(SELECTEDVALUE(PassageStock[DateSortie])<MinDate,1,0)
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.
@patoku0207 use MAX or MIN instead of SELECTEDVALUE
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.
hello and thanks for your answer. Unfortunately SELECTEDVALUE is not recognized .
I use a direct connection to analysis services and dont import datas.
@patoku0207 try this:
Filtre_Cas_1 =
var MinDate = FIRSTDATE(Calendrier_SIF[DateSQL]) ' 01/09/2023 in this example
var MaxDate = LASTDATE(Calendrier_SIF[DateSQL]) ' 30/09/2023 in this example
RETURN
IF(SELECTEDVALUE(PassageStock[DateSortie])<MinDate,1,0)
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |