powerbidaxpowerbi-desktop
Creating a new table that list the unique values of a Column from another table - Power BI/DAX
Im new to the Power BI environment, please go easy on me.
I have a table that has a list of locations for transactions. I need to create a table that list each location just once but will adapt as the locations change. Please guide on on where to start!
-JimmyD
Solution
Create a new calculated table using DISTINCT('YourTable'[Locations])
- Setting moving default start and end Date in power BI
- Power Query Conditional JOIN - JOIN with WHERE clause
- Power BI: Count the number of times a text appears in each row
- How to sort weekdays in Power BI based on today
- What are the minimum Azure permissions required to publish a Power BI report using "App Owns the Data"?
- Filter multiple visualizations to exclude values that have already been excluded
- How to count direct and indirect test cases for Features, Requirements, and Change Requests in Power BI using DAX?
- Group average as a baseline & individual variance to baseline
- DataFormatError whenever I filter a column
- How to structure input to use PowerBI REST API: multi-value parameters
- Data missing from basic visual in Deneb (vega-lite)
- Microsoft Power BI REST API PowerBINotAuthorizedException
- Filtering values on one visual affects filtering on second visual
- PowerBI Embed in Angular "User Owns Data" | Getting InteractionRequiredAuthError: AADSTS65001 while generating powerbi access token
- Displaying a Fixed Timeline in a Power BI Line and Clustered Column Chart with Slicers
- Integrate PowerBI report using 'embed for customer approach' to angular application which use OKTA to authenticate
- Why do fields still show in PowerBI when I have them filtered in the model?
- How to sort a line chart X-axis by a different column than displayed
- Row Comparison in PowerBI
- PowerBI Slicer showing single value from group of values
- Sorting Months in a Power BI Visual by Fiscal Year and Month
- Power BI report of excel data source
- PowerBI REST API get reports
- Reference another table when getting data from Python in Power BI
- Power BI - Powerpoint Export is Not even Showing
- Is it possible to schedule refresh in Power BI with Windows Task Schedule?
- PowerBi measure where the total is based on the legend and adjusts total for selected slicer
- DAX problem - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value
- How do I create a bar plot histogram of a parameter in power BI
- How to show a colum total in a Power BI matrix visualisation that has implicit columns based on values?