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.
Hi, i have a M query that load a value from Excel (Region)
let
Table_Parametres = Excel.CurrentWorkbook(){[Name="Tableau4"]}[Content],
Region= Table_Parametres{1}[Valeur],
...
and i would like to filter only if there's a value in the Region parameter
i wrote this :
#"Lignes filtrées"= if Region<>0 then Table.SelectRows(#"Colonnes supprimées", each [TREGION] = Region) else Table.SelectRows(#"Colonnes supprimées", each [TREGION] = "")
but i would not NOT filter is the Region is empty (actually he filters the TREGION="" )
Could you help me ?
Not sure if I understand your request, but would this work?:
#"Lignes filtrées"= if Region <> null and Region <> "" then Table.SelectRows(#"Colonnes supprimées", each [TREGION] = Region) else #"Colonnes supprimées"
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Worked great for me! Thank you!
Calling in @ImkeF
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |