Category "dax"

How can I add a column with find the closest date found in a second table using dax or m?

I have two tables. One with dates of tech support given, and the other one with surveys sent to the customers. The problem is that the surveys are sent some day

Sort column circular dependency in Power BI

I have to sort month name from January to December in Power BI Desktop. Power BI sorts the column according to the alphabetical order. Here is my dataset: When

Power BI : filter on a rank

I have calculated ranked using this formula which worked perfectly well : RANK = RANKX(ALL(td_store[LIB_MAG]), CALCULATE(SUM(tf_market_share_by_store_nomcenclat

How can I get total amount value for each different user in PowerBI

I want sum all 308 values in userprofileid column to get the total amount of the values for that user in the amount column This image shows GROUPBY(userprofile

How to count rows in a table, where a specific column value is in a list of specified values?

How do I create a DAX measure to count the number of customers in a customer table dCustomers, where the customerType is either FR, DE or GG? In SQL, this would

a function calculate has been used in a true/false expression that is used as a table filter expression which is not allowed

I have a to check the current month and current year value for a measure in ssas tabular model but due to type mismatch i am not able to do this. For this, i ha

How to display nulls in PowerPivot using DAX

I have heard amazing things about PowerPivot but for me it's not been so helpful. Pivot charts are often using a count function and this is where me and PowerPi

Comparing values of type Text with values of type True/False

I have a data column of strings containing a lead status. I only want to count if the lead is qualified or nurture. I have this expression: Is Qualified = If

Other Categories