Skip to main content

Posts

How to check table 1 value exist or not in table 2 without any relationship

In Power Bi, how to check table 1 column values are exist in table 2 or not, when there is no relationship between both tables?

Create a Calendar Table in Power Bi using DAX functions

Calendar table is frequently used to perform Time Intelligence functions and in many scenario we need calendar table. If you don’t have any date table in your data model, you can easily create date table using some DAX functions.

SWITCH DAX Function

Evaluates an expression against a list of values and returns one of multiple possible result expressions. It’s comes under Logical Dax function category.

ALL DAX function

As it’s name suggests, Returns all the rows in a table, or all the values in a column.  ALL function removes the applied filters from the filter context. Its comes under Filter function DAX category.