Accts Receivable Total Overdue
Hi Community, Wonder if you could help me, Within AR i'm looking show the total ocverdue within the below, currently i'm using a measure to determine the age of the debt by days and then actergorising them to 61+ , 60 - 31 days etc as per below, what i'm trying to do is total the overdue values (61 + through to 7-0 columns) and have this within the total overdue column I've looked at inserting a template to sum each date range but that's not quite working , below is showing how the days macth the range but a bit lost to show how sum teh of the overdue witthin the above Any help would be massively apprciated and if you know of where to look on the net to help improve my dax knwoledge would be great also Many thanks Chris
How to use same string value in nested if conditions
Hi, Could someone please help on this. Below is the nested if condition I wrote. It is simple nested it formula and the logic behind it is also simple. Recurring GS + Price Col = IF('Table'[Account Description]="Recurring Gross Sales" || 'Table'[Account Description]="Recurring Price", "Recurring Gross Sales + Price", IF('Table'[Account Description]="Recurring Gross Sales" || 'Table'[Account Description]="Recurring Price" || 'Table'[Account Description]="Recurring Cancel" || 'Table'[Account Description]="Recurring Migrations" || 'Table'[Account Description]="Recurring Backlog Migrations", "Net Sales", BLANK())) Below is the output when using the above formula But, the expected output for Net Sales is below Any help on this please!
Cumulative formula inside IF formula
Hi Team, I am looking for a formula that can help me in planning my repair. I have an if function but eventually I need to reapply the calculation based on the new value coming after the previous calculation. The below screen can explain better what I am looking for This is my main formula. But the value of UR should be re-evaluate based on how many I repaired the previous week My Result should be in the Cumulative Under Repair for same Concatenate Tool Code (which is wrong now!) For 19 May = 2 (just the qty I neew based on String per week) 26 May = 0 (no demand so no need to repair) 2 Jun = 1 (because I have already repaired 2 19 May so my new count of UR is 1 and RTG is 40 9 Jun = 0 (because I have repaired all UR already) 21 July = 0 (because I have repaired all UR already) I am struggling how to include this cumulative in the formula. Anybody can help? Appreciate all your support Regards
help with formula to calculate time
Hi i am having issues with trying to get hours counted, i want it to return Substantive Filled total hours Month Status Hours Oct Substantive Filled 01:00:00 Oct Filled 01:00:00 Oct Filled 01:01:00 Oct Substantive Filled 02:00:00 my hourscolumn is formatted as belowDAX formula to repeat text series in a column
Hello guys, I wonder if there would be a DAX formula for a conditional column where these 3 items are repeated continuously: Distributor Wholesale Retail Then the loop continues again with these same values from distributor to retail and on and on as long as a value exists in the cells of another column that I specify.Using variables to normalize a score is not working
Hi I'm trying to normalize a score by the following DAX formula, where I use a variable table and two variable values. But it is not working as you can see in the screenshot. I get the value 0 for all suppliers. I would expect the value to the left of the column '_Normalize score LT vs AT'. In the screenshot you can see the correct results in the column 'Normaliseret', but this calculation is made of a calculated table and 3 separate measures. So I just try to build these measures (calculations) in to one measure '_normalize score LT vs AT'. I'll appreciate if someone could help me in the right direction? _normalize score LT vs AT = var MaxLTvsAT_table = SUMMARIZE('data-leverandørperformance', [Leverandør ID], "@_pct_LTvsAT", '1. Measure Tabel'[% Lead time vs Aftalt tid]) var pct_LTvsAT = DIVIDE([Gns. LT vs AT],[Gns. Aftalt leveringstid],0) var MaxLTvsAT = maxx(TOPN(1, MaxLTvsAT_table, [@_pct_LTvsAT],ASC),[@_pct_LTvsAT]) return if( pct_LTvsAT<0, 100, 100-(divide(pct_LTvsAT,MaxLTvsAT,0)*100 ) )
Calculating Burn rate monthly compounding
Hello, I would need some help in a formula to put in PowerBI to calculate the burn rate, but for it to be compounding over a monthly period. I have a couple of values that are being used. Monthly Actuals, Month, and Monthly Burn Rate. Monthly Actuals = Amount of FTE burned in a month Months = months throughout the year Monthly Burn rate = Monthly Actuals/12 (helps get the monthly FTE burn rate) I would like this burn rate to be coumpouded from the previous months burn rate. For example if January had monthly actuals of 140FTE, this / 12 = 12. Then February has a monthly actual of 160FTE, dividing this by 12 would equal 13.33, the burn rate would then be (12+13.33) = 25.33.
