• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Distribution of hours worked by employees en DAX

    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...
  2. A

    Percentage of row amount over previous row

    Incredible, very good trick!!! Thank you very much!!!
  3. A

    Percentage of row amount over previous row

    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.
  4. A

    Get the price update factor

    Very good Chihiro!!! I've been able to fix it. Thanks a lot.
  5. A

    Get the price update factor

    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...
  6. A

    Get the price update factor

    That's right, your solution is very good, but I've omitted to say I wanted to do it with Dax formulas. I've tried some for I haven't been able to.
  7. A

    Get the price update factor

    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...
  8. A

    customers visited and not visited

    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...
  9. A

    Power Pivot Relationships failed

    Thank you all for sharing.
  10. A

    Power Pivot Relationships failed

    Excellent Chihiro!!! Thanks a lot. I'm not an expert, but this problem made me feel like a beginner. :-))
  11. A

    Power Pivot Relationships failed

    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...
  12. A

    Power Pivot Relationships failed

    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.
  13. A

    Power Query - Check all Columns

    Ok, it's an Excel table. Thank a lot.
  14. A

    Power Query - Check all Columns

    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...
  15. A

    Accumulate using variables-addcolumn-Filter

    Thank you Chihiro!!! Very good contribution.
  16. A

    Accumulate using variables-addcolumn-Filter

    Very,very good.Excellent!!! Thanks for the answer.
  17. A

    Accumulate using variables-addcolumn-Filter

    Thank you very much Hui, but I intend to do it using Dax.
  18. A

    Accumulate using variables-addcolumn-Filter

    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...
  19. A

    Board indexPower Query Get start and end date of the current and last semester of the calendar year

    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.
  20. A

    Board indexPower Query Get start and end date of the current and last semester of the calendar year

    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...
  21. A

    Example Transition Context in Dax

    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...
  22. A

    Example Transition Context in Dax

    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.
  23. A

    Example Transition Context in Dax

    Thank you very much. I leave the original link: ""
Back
Top