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'm getting data from dataset so i can create new new group field. Can i do it working with DAX?
thanks
Solved! Go to Solution.
I have a list of strings inside a field:
DN_AD
DS_AD
DW_AD
DN_AA
DS_AA
DW_AA
...etc
As you can see the first 3 end with AD and the last 3 with AA
I would like group named "AD" with the following string
- DN_AD
- DS_AD
- DW_AD
and a group named "AA" with the following string
- DN_AA
- DS_AA
- DW_AA
I hope this can help you understand what i need
you have created a table.
I need to use this new goup to filter others things
Take a picture of the dataset please, im not quite sure what exactly it is you're looking for.
I need to create new measure with this new group "AD" AA"..etc
As you can see pressing rigth mouse botton i can't creata the new group
A group cannot be created on the table. Right now you are right clicking the Account table. You need to create the group on the column that you are using to define the different groups.
with this dataset i can't create columns that why the reason i'm asking help to create these measure with DAX
Oh okay. Measures only hold scalar values so you will not be able to create a category using a measure.
What kind of a query is it if you cant create calculated column?
i dont need to create a query. I want only to create a new group with DAX that includes some strings
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |