## How can I join tables using only DAX?

You can see this below example: FILTER('InternetSales_USD' ...READ MORE

## DAX function to create LY Measure without date dimension

It should be fairly simple (sumx of ...READ MORE

## DAX EARLIER() function in Power Query

Solutions in the code below. Notice that ...READ MORE

## How to ignore a slicer for one measure, but apply it on another?

In order to ignore Slicer you need ...READ MORE

## Hi, I am learning Power BI and trying to understand how calculate works without filter? = calculate(sum(sales.total_amout)). why cant we give sum(sales.total_amount)?

Hello @Amitha, The CALCULATE function is useful because ...READ MORE

## Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

## Recursive logic in DAX

Hey,  The only option is to break down ...READ MORE

## Recursion in DAX

You can check this out:  DECLARE @myTable as ...READ MORE

## How to calculate average inventory in power bi?

Hi @There, Is there any index field in ...READ MORE

## DAX Calculation the Max for a Group.

You can try this out:  Desired Output=CALCULATE(MAX([Check]), ...READ MORE

## How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

## How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

You can simply write a few measures ...READ MORE

## Error : Function 'GROUPBY' scalar expressions have to be Aggregation functions over CurrentGroup().

The error says you need to use ...READ MORE

## Power Bi Questions

Hi, @Vnk, Despite the efficiencies achieved by the ...READ MORE

## Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

## DAX Calculate function with and without FILTER

You could make [Measure12] return the same results as ...READ MORE

## What is the difference between DAX and Power Query?

DAX stands for Data Analysis Expressions. DAX ...READ MORE

## What is the difference between PowerPivot, Power Query and Power BI?

Power Query Power Query is a self-service ETL ...READ MORE

## How to troubleshoot a refresh on data set in power bi service

Hello, @vnk, You may see an error when ...READ MORE

## How can I make my visual distinct count total match the row by row sum when applying filters in PowerBI?

The COUNTROWS function can be used to ...READ MORE

## If invoice date is <= OTD then OT else Late and if OTD is blank then OT

I am getting an error message. I ...READ MORE

## Calculate GB Using DAX in Power BI

Hi, @Vnk You can go through this regarding ...READ MORE

## Dax Calculations on Date&time

Hey, @Vnk, I hope you have a data ...READ MORE

## After connecting SharePoint List with Power BI, and editing data in query, all the data I want are in links

I've try so many ways to decode ...READ MORE

## Dynamic title Based on Date

Hi, @Vnk, You can try this: [Date(WindowMax)(Title)] = WINDOW_MAX( ...READ MORE

## how to write dax calculation Power bi

Hi, @vnk You can make use of this ...READ MORE

## Custom report create based the user details in our application via power bi report the data automatically change in our application.

Example the user select the text box ...READ MORE

## Combine two tables, filtering out duplicates from table two.

I want to combine two tables into ...READ MORE

## How do I install PowerBI on Ubuntu ?

Hi, @Bhagyashri, Based on my research, currently, it ...READ MORE

## file must be character string

I am struggling with environmental asscocition analysis ...READ MORE

## How to use play axis in stocked column chart

Hey Katyvin, If you want to use the ...READ MORE

I am trying to export data from ...READ MORE

## How to work on existing power query using python

Hi I have an existing power query created ...READ MORE

## How to Create and use doughnut charts in Power BI?

Hey, To create a doughnut chart in Power ...READ MORE

## How to create a new dashboard by pinning visualizations from a report in Power BI?

Hey, I can show some steps wise steps ...READ MORE

## How to create Pivot Tables in Power BI?

Hey, First of all, there is no "Pivot ...READ MORE