Search code examples
powerbidaxpowerbi-desktoppowerbi-datasourcepowerbi-custom-visuals

How to create new table from existing table using DAX query on PowerBI?

I'm trying to create a new table using the existing table using the DAX query of PowerBI, Is there any Best options?

My table is

enter image description here

Solution

  • Go to the Modeling tab and select a new table option

    enter image description here

    You will get the DAX query edit option something below

    enter image description here

    Query: Write your query to create a new table from an existing table

    CustomerOccupation = SUMMARIZE('KPIMapReduce?limit=10000&stale=false&connection_timeout=60000&inclusive_end=true','KPIMapReduce?limit=10000&stale=false&connection_timeout=60000&inclusive_end=true'[CustomergetOccupation],'KPIMapReduce?limit=10000&stale=false&connection_timeout=60000&inclusive_end=true'[ClerkCount],'KPIMapReduce?limit=10000&stale=false&connection_timeout=60000&inclusive_end=true'[DriverCount],'KPIMapReduce?limit=10000&stale=false&connection_timeout=60000&inclusive_end=true'[FarmerCount],'KPIMapReduce?limit=10000&stale=false&connection_timeout=60000&inclusive_end=true'[WorkerCount],'KPIMapReduce?limit=10000&stale=false&connection_timeout=60000&inclusive_end=true'[OthersCount])

    Result: Our new table is ready

    enter image description here