dax forumlas

  1. G

    Need DAX formula for the below situation in Power BI

    Hi Team, I have no idea of how to write a DAX for the below situation. At least a hint would give me the right direction. In the image, the 1st table refers to the data table. It has 2 date columns and 2 text columns In the output, for each row I want it to count the number of records that...
  2. C

    Calculate Active Billing Values in a given month (Power Pivot)

    Hi all, I have been hunting for an answer to this for days and just getting nowhere :eeek: We have a table of rental service charges that have 4 key Fields; Start Date End Date Quantity Sell Price I have created a Date (calendar) Table and created a relationship to both the Start Date &...
  3. K

    DAX, how do I return a particular value when have multiple lookup critierias?

    What is the correct syntax for the following situation? I have two tables ResPlanData, SalaryEmpDetail I need to look up the salary value for those employees who fall under the following criteria. Name matches in ResPlanData, where ResourceType ="Salaried W/2" If StartDate is prior to...
  4. K

    Convert Excel function into DAX

    How do I convert the following, so I can use it within the query (DAX)? =IFERROR(IF([@ResourceType]<>"Salaried/W-2","",LOOKUP(2,1/(([@Resouce]=SalaryDetail_Data!A:A)*([@Dates]=SalaryDetail_Data!C:C)),SalaryDetail_Data!D:D)/12),"") thanks, Karen
  5. C

    Year on Year Growth - No Date Day Field

    Hi, New to PowerPivot. Currently migrating some reports from Excel to Excel online and get them to feed off PowerPivots. It seems I need to create a DimDate table/tab in my PowerPivot in order to use the DATEADD formula in order to calculate year on year growth (in say Sales for example). I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top