Hello, I need help to be able to classify the hours worked by the employees of a company into a time range (from 0 to 6, from 6 to 12, from 12 to 18 and from 18 to 24) ( You have an employee table with the hours worked by date). I developed the example in excel, but I need to do the same in dax...
Hello, I have the following table ,
, my question is to know how I can get by DAX, the percentage of a row with respect to the previous one, which is what is colored in red. The idea is to develop a measure (not a calculated column).
Regards.
Thank you very much, very ingenious! This is just the solution that I have to get to, but for the exercise, I have passed only a summary, to focus directly on the problem I have. Now I tell you everything, it happens that I did not want to complicate.
I'm working on Power BI. I need to get a...
Hello, I need to get a table of factors from a table of prices per month and per year. Below I show the Price table and what to get:
You must get the division of each month and year for the same month but last year. For example the price of the month of January/2015 should be divided by...
Hello, I have two tables, one with customers and the date that have been visited, and the other is a calendar table. I need to show a table with customers who have been visited and another table with those who have not been visited within a range of dates taken from a slicers. I have developed...
It's just something very basic, and that's what draws my attention: it doesn't work. Supposedly this should work easily just by establishing the relationship. I do it in Power BI and it works. Apart is common for a table of employees to get from the category table the salaries. I appreciate your...
I have two tables, one employee and the other with the categories. I’ve created the relationships between them through the Id category field, and I can’t find the reason why it doesn’t work. I’m using Excel 2016. It’s a very simple thing but I can’t find the error. Attached the file. Thanks a lot.
Every month, I need to perform a repetitive process, for which I need to verify that all the necessary columns are found in the table of origin. For example, in a table I only need the following columns: Employee, payment and discount, but sometimes the discount column does not come in the...
Given a certain table with the following structure:
Date-Item-Amount-Type
01/01/2016-1234- 100- AA
02/01/2016-1500- 250- BB
04/01/2016-1500- 400- BB
05/01/2016-1500- 300- AA
05/01/2016-1234- 500- BB
You want to totalize by date and by Item. The type "AA" defines that the amount must be...
Thank a lot!!! Very well accomplished. I have only modified "End Of Previus Semester": Date.EndOfMonth (date. AddQuarters ([End Of Semester],-2)), because in some cases it took as end of the semester "30/12/2017".
Regards.
From an X date, I am interested in finding ("M") the starting and ending date of the current semester and the starting and ending date of the previous semester, of the calendar year. For example, today is 10/02/2018. Start current semester = 01/01/2018, date of completion of the current semester...
Hello. Actually, I'm just doing an exercise raised by Brian Grant at "", trying to use his own didactics, for personal learning, and to share with others. It has been hard for me to solve it, and it has taken several headaches. Thank you very much for your comments and contributions, have served...
Thank you very much Guido. You really helped me a lot, and I made a guide showing visually how the transfer of contexts is done when using calculate. I’d like you to see her and give me your opinion. I think it might help others to understand the idea.
Attached two Excel books.