User Profile
Murkow
Frequent Visitor
Joined 9 years ago
User Widgets
Contributions
Matrix - total column independent on columns
Hi, I'd like to ask you for an advice regarding visualisation of data using Matrix. I have my own calculated Total column I want to use. But for the data visualisation I have Project Categories as data columns. I have the amount of hours displayed in every Project Category column. But I want the calculated Total value independent on the Project Categories columns, but if I put it in values, it is in every Project Category for the particular category only which is not what I want. Thank you in advance!Calculated column based on formula, filter and date - using slicer
Hello everybody, I'd like to ask you for help with a calculated column. I'll use the following table to demostrate it on an example In order to get the Requested column I use this formula: Requested = CALCULATE ( SUM (Query1[hours] ); FILTER ( ALLEXCEPT ( Query1; Query1[User] ); Query1[project_category] <> "_Attendance" ) ) It works, however, when I use the slicer for the visualization, the date slicer doesn't have any influence in my new column and it still returns only one (the total) value. Is there anything I can do about that? Any formula taht cooperates with the date and will return a value only for the time period I filter using the slicer? Thanks in advanceCalculating based on filtering column values
Hi everybody, I'd like to ask you to help me with a DAX formula. I have this situation I need to get the formula for the yellow Requested column. The logic is following: I need to calculate all hours of every user that are not _Attendance Thank you in advance.Return 1 if any row with the same name contains 1 in a particular column
Hi, can't think of formula no matter how hard I try I'll demonstrate it on an example to make it easier to understand. I have multiple rows with the same name. Then I have date. I made a new column where I find out, if the row is from this week (return 1 if it is) Now I need a New Column, where it retuns 1 to every row, where there is at least one 1 in This week column for that project. Any ideas? See the screen below. Thanks in advance Project 2 has no 1 in nolumn This week which means it has 0 in every Project 2 row in New Column. Project 1 and Project 3 have at least one row where there is 1 in Column This week so there is 1 in every Project 1 and Project 3 row in column New Column. Please, how do I get the New Column formula?
