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...
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 &...
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...
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
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 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.