power

6 Topics

Calculate difference between multiple columns and then highlighting the difference
Hello I am trying to calculate the difference between mutiple columns in PowerBI. And Highlight changes above and below 50 w/ color. I haven't been able to find any examples with multiple columns. I believe I have to create a measure but I'm not sure what calcualtions to use. Any help would be much appreciated.
Sk1_2
2 years ago Place DAX Commands and Tips
2.3KViews
0likes
4Comments
Loan amount to get updated same day next month
I have a one row per person with details related to his loan start and end date, repayment and installment amount information, what I want to get is the balance as on date. for example, Person A got loan of $100 on 6/9/2023 which has installement amount of $8 then every month 6th the value should get updated with $100 - $8 and the values should be repeating for slicer selection till next month 6th is encountered. Shown in the image below. The balance as on date is a measure and I have multiple tables and date dimension. I have tried different things nothing seems to work. I ideally want to count every 6th of the month as one month and calculate the balance amount as on date for that particular month. Which is becoming tricky. Please help. Ritaf1983 amitchandak
raji_n
2 years ago Place DAX Commands and Tips
366Views
0likes
1Comment
Smart tooltip for Matrix rows
Hi Dear Community, I am trying to use a column from a table (which has 1:* relationship with the table from which I constracted my matrix) as a tooltip for my matrix rows. But I want my tooltip to show the particular value from that column which corresponds to the value of the row of the matrix I hover over. I wuold appreciate your help. Thank you in advance!
Anonymous
4 years ago Place DAX Commands and Tips
4.8KViews
0likes
1Comment
Distribute subtotal of specific type on other rows
Hello, i am quite new to DAX Commands and PowerPivot but i am trying to achieve the following and am quite sure that this should be possible quite easy. At the moment i have a classical pivot table of multiple levels which has the following hierarchy BRAND => ITEM => COST DIMENSION What i want to achieve is to dynamically calculate a Subtotal of any existing BRAND<=>ITEM combination which i am then using as a multiplier in order to distribute this subtotal on any existing row based on their particular percentage share. In the table below i would need a measure which saves the Cost for Type = Storage and then distributes this amount on the corresponding rows above based on their percentage share. This has to be done also for the following brand<=>item combinations as this is just illustrating the first group of many. Hope i made myself clear. If not, please feel free to ask! Thanks a lot! BRAND ITEM COST DIM COST TYPE COST AMOUNT COST % 011 123 XX GENERAL 10 10 011 123 XY GENERAL 10 10 011 123 YY GENERAL 80 80 011 123 - STORAGE 120 0
Solved
padinator
4 years ago Place DAX Commands and Tips
2.4KViews
0likes
7Comments
Need Dax Help Please!
Hi guys I have 2 tables. They are related through the Task column i need to write a calculated column that gives me a count of each task. Seems simple but the part that's tripping me up is if the task is task 3 or 4 then I need the count of those together in the calculated column. The one I wrote doesn't add them together. Here is an example table and my desired result. Thanks! Name Task John 1 John 1 John 2 Jim 1 Jim 2 Jane 1 Jane 2 Mike 3 Mike 4 Evan 3 Evan 4 desired result Task Calculated column count 1 4 2 3 3 4 4 4
Bpark1994
5 years ago Place DAX Commands and Tips
1.2KViews
0likes
3Comments
PowerBI: Count values in a Matrix
Hello All, I am trying to figure out how to count the values inside a matrix in a measure. My raw data looks like this. I have a large number of values and a large number of categories that the Category Type can be. VALUE# Category Type Value1 Category 1 Value1 Category2 Value2 Category3 Value 2 Category 3 Value 3 Category 30 I would like to be able to identify if any duplicates exist per Value. For example, in a matrix it would look like: Category1 Category2 CategoryN Value1 Count of category1 Count of category2 Count of categoryN Value2 Count of category1 Count of category2 Count of categoryN Value3 Count of category1 Count of category2 Count of categoryN So that my final data can look like: Is there any duplicate? Value 1 No Value2 Yes Value3 No I am interested in wrapping this up to a measure rather than show the visualization of the matrix in the report.
Solved
eryan123
5 years ago Place DAX Commands and Tips
8.5KViews
0likes
5Comments