Top "Dax" questions

Expression language used in Microsoft Power Pivot, SQL Server Analysis Services Tabular, and Power BI for performing analytical calculations.

how to convert a Integer to Text value in Power BI

I am creating a calculated column in existing power BI report. the calculated column concatenates integer & text columns. I …

sql powerbi dax m
How to format new measure (not column) in power BI as percentage?

When I create a new measure with formula, i.e. sum(col1)/max(col2), it automatically converts the result into #.#% …

powerbi dax
How to get month name from month number in Power BI?

I have Year number and Month Number in my data. How using DAX can I get the month name out …

business-intelligence powerbi dax
Multiple IF Statements in DAX

I currently have Column Data formulated below in Power BI which I need for it to display in one column …

if-statement powerbi dax
Using Multiple filters in DAX

I'm new to DAX. I'm currently using Power BI and trying to create a total sum of sales that use …

excel pivot dax powerbi
Power BI, DAX--How do I count rows in one table based on values in another table?

I have two tables, lets call them Table1 and Table2. Table1 has a column of unique values, Table2 has a …

count powerbi dax
Match and Get the Value from another table (Vlookup)

I have 2 tables connected to each other through col A. I want to match the column C with Col A …

powerbi match dax vlookup
DAX formula to concatenate three columns

I am mew to DAX. How can I concatenate three different columns say First_Name, Middle_Name and Last_Name …

concatenation ssas dax
PowerPivot DAX: Identify Max & Min Value per Group

I am in need of identifying the maximum and minimum value per a defined group within a PowerPivot connected PivotTable. …

max min powerpivot dax
Power BI (DAX): Distinct Count Filtered by Condition

I have a data set with publishers with revenue by month. Publishers are considered to be "active" month if their …

excel excel-formula dax powerbi