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 have a dataset S:
Col1 Col2
A 1
B 2
C 3
And I have a parameter TestPar (not required, any type)
During data load I want to set TestPar = 2 (value Col2 when Col1="B") and then continue to dataset S transformation (for example remove top rows and addcolumn)
Any ideas?
Thnx!
Hi @az38
You may go to 'Manage Parameters' to set and use it in query editor.Below is the article about it.
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Regards,
Cherie
There is a good solution to create new column and fill it https://community.powerbi.com/t5/Desktop/Get-data-from-single-cell-in-DataSet-M-Language/m-p/625782#...
But what if i don't want to create new column and want to store value from the cell somewhere
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |