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.
If I have created a dataset in PowerBI Desktop then I can see all the calculated columns etc.
I have a prebuilt dataset that I would like to understand the content of the calculated columns. How can I do this? I can see the columns are calculated from the little Icon but I cannot dig into this. Anybody got any ideas?
Trev
Solved! Go to Solution.
If you are referring to a .pbxi file simply open it in the desktop version and navigate to the table containing the measures in the data model (signified by the table looking icon to the left of the workspace in red). Make sure you have the correct table then scroll down the fields until you see the measure (circled in blue on my image). Click on it and it will show you the DAX in the measure field where it can be edited or copied to create a new, similar measure (in Green).
Hope this helps.
EDIT: Of course this is a file that was "pre-built" by me or could have been "pre-built" by a coworker. Content packs and such are different.
Proud to be a Super User!
If you are referring to a .pbxi file simply open it in the desktop version and navigate to the table containing the measures in the data model (signified by the table looking icon to the left of the workspace in red). Make sure you have the correct table then scroll down the fields until you see the measure (circled in blue on my image). Click on it and it will show you the DAX in the measure field where it can be edited or copied to create a new, similar measure (in Green).
Hope this helps.
EDIT: Of course this is a file that was "pre-built" by me or could have been "pre-built" by a coworker. Content packs and such are different.
Proud to be a Super User!
When you say prebuilt data set, are you referring to using a Content Pack?
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 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |