Creating new Power BI Table by filtering values from another table column

preview_player
Показать описание
Power BI data modeling tutorial where I'll show you how you can create a new table from an existing table but filtering its values from a specific values of column of another table. This will help first filtering the existing table by another table column and then create new table for reporting needs. Here we'll be using DAX functions like calculate table, filter and related to build the expression and then create a new table.

  1. Data Science Tutorials
  2. power bi calculate table function to create new table
  3. power bi calcualtetable function with filter function
  4. power bi calculatetable function with related function
  5. power bi filter function with related function
  6. creating new calculated table in power bi
Рекомендации по теме
Creating New Power 0:06:06

Creating New Power BI Table Based on specific values of another table

How to Create 0:04:28

How to Create a New Custom Power BI Table

How to Create 0:05:25

How to Create a New Table in Power BI from Existing Table Based on Filter Conditions

Creating new Power 0:04:59

Creating new Power BI Table by Combining Distinct Values from Multiple Tables

How to use 0:08:34

How to use SELECTCOLUMNS and ADDCOLUMNS to generate new tables in Power BI // Beginners Guide

Create a Table 0:04:24

Create a Table in Power BI using Enter Data and How to Edit it

How to Create 0:05:42

How to Create a New Measure Table in Power BI to Keep All Measures at one Single Place

Creating a Custom 0:02:49

Creating a Custom Table in the Microsoft Power BI Query Editor

Power BI inactive 0:05:11

Power BI inactive relationships with CALCULATE & USERELATIONSHIP

Creating new Power 0:06:58

Creating new Power BI Table by filtering values from another table column

4.1 How to 0:02:10

4.1 How to Create a Table in Power BI Tutorials for Beginners by Pavan Lalwani | Creating a Table |

Power BI Tutorial 0:11:01

Power BI Tutorial for Beginners 9 - Creating Tables in Power BI

Creating a simple 0:07:50

Creating a simple date table in Power BI

Data Modeling (Star 0:24:54

Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables

[Power BI] How 0:05:08

[Power BI] How to Create New Summarized Table from Existing Table

Handling MULTIPLE fact 0:09:02

Handling MULTIPLE fact tables in Power BI

Power BI Tutorial 0:23:03

Power BI Tutorial For Beginners | Create Your First Dashboard Now (Practice Files included)

Using Column as 0:00:32

Using Column as measure in Power BI table/matrix

DATE TABLE for 0:21:26

DATE TABLE for Power BI using Power Query

Hands-On Power BI 3:02:18

Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡

Create Static Tables 0:13:38

Create Static Tables in DAX Using the DATATABLE Function

Creating a Table 0:08:07

Creating a Table in Power BI Using DAX Table Constructor

Ultimate Guide to 0:03:24

Ultimate Guide to MATRIX Tables in Power BI | 2023

DAX Fridays #201: 0:07:02

DAX Fridays #201: How to create virtual tables using DAX

Комментарии
Автор

is it possible to use Filter with non-related tables? I created a table from an excel with many columns and rows to be used as filters as there are many conditions and I can't make it work.

criztina
Автор

Hello Abhishek,
Thank you for all your nice videos.
This solution works only if filter direction from many to one bcz related function pass the information from M to 1 direction.

Is there anyway to do this filtering from 1-M side (ex :FILTER(table1,
Table1 : Present at 1 side of relationship.
TableM : Present at M side of relationship.

nidhisingh
Автор

Hello Abhishek, is it possible to input “P01, P02, P04” by the user dynamically?

hpewtyp