Formula for volume of incidents by hour of day
Formula to count how many calls by the Start of hour column 44 seconds ago I need help figuring out how many "instances or calls" occured by the hour (start of hour). I have a column labeled Start Instant Date and i created a new column putting start time by "start of hour" . I just want to know the volumn of calls or instance by day, by the hour (example, there were 30 times someone called a dr on 10/2/2024 at 12pm) The table is called Transfer Data and i would like to use a line/bar graph with date as X axis and hour as Y axis
Date Measure across end of year
I keep running into this issue and I'm hoping that there is a standardized way to do this. My company measures a lot of data by "date of event". That data is then tabulated by current period and prior period (e.g. current week/prior week, current month/prior month). Every year, in January, we run into an issue because the prior week/month is also in a different year. So, a formula like =IF(MONTH([Event Date])=MONTH(TODAY()),"CURRENT",IF(MONTH([Event Date])=MONTH(TODAY())-1,"LAST","OLDER") breaks when Dec (12) and Jan (1) are the elements because 12 <> 1-1 Is there a standard way of handling this?
Formula: Greater than a value inclusive for multiple conditions
Can't seem to figure this one out.... I have a custom column that I will use as a slicer. Effectively, the column should give me the following: >$1M >$2.5M >$5M >$10M So if the Grand Total is $6.7M it should appear in three of the above conditions (in a slicer). However, I can't get the formula right... I don't want ranges (i.e. >$1M and <$2.5M). I'll need them to be inclusive and apply to any and all of the categories listed previous. Thanks in advance!
How do I create a measure to sum (total) up a distinct count?
Hi guys, As you can see in the picture down below I created a table with different colums: First column [VullingTotaalPerc] shows the percentage of version ID that are filled 100% and so on Second column [Count of Versies.Id] shows the count (distinct) of the total version ID. Third column [TotalVersiesIDCalculate] is a measure that I created that shows the count (distinct) of the total version ID but only for department X. Measure = TotalVersiesidCalculate = calculate(DISTINCTCOUNT(MKA[Versies.Id]),MKA[ProductieAfdeling]="COC2 en I&V") Fourth column [DistinccountVersies.id-Calculated] is a measure that I created that show the count (distinct) of versies.ID. DistinccountVersies.id-Calculated = DISTINCTCOUNT(MKA[Versies.Id]) Fifth column [COC2-Calculated] is a measure that I created - [TotalVersiesIDCalculate] divided by [DistinccountVersies.id-Calculated] to show what the percentage is of the total amount. The problem now is that when I use this formula: [TotalVersiesIDCalculate] / [DistinccountVersies.id-Calculated] the measure will divide 8 with 56 but what I want is that 8 will be divided by the total of 2533. Can anyone help me out here? Thnx!
Check every 15 days
hello, tell me how to implement the following task in POWER BI. Thank you! What is: - the date of the operation - email (not unique) - transaction amount - whether the payment was confirmed or not I need to find/calculate: - for each user (email), the first and last transaction (amount) - but such a "procedure" should take place no more than 15 days after the FIRST operation. For example 1, the client made the 2nd operation 16 days after the first, then it will appear twice in the report, because more than 15 days have passed. The amount of the first and last transaction for this client will be equal. For example 2, the client made the 2nd operation after 10 days, it will be in the report once, but with different amounts of the first and last operation. For example 3, the client did the 2nd surgery after 3 weeks, the 3rd after 4 weeks. We need to "merge" data for 3 and 4 weeks. The client will also be in the report twice.DAX Measure For Calculating Stocking Levels
Hi all. I am trying to create a DAX formula/measure that calculates necessary stocking levels based on several different inputs. The biggest input is the install base. Even though it is a very ugly formula in Excel it has worked for a very long time. To start I've created two parameters to use in the mesaure, install base and lead time. Both of these can be with a high range for install base and two choices of for the lead time. I'm stuck at this point. I've tried SWITCH TRUE (), and an IF statement. On both I get stuck on the second SUM category so I don't know if it even works beyond that. This picture shows the dependents within the Excel formula. I've attached the link to the Excel file: https://1drv.ms/x/s!Apq9nVxrTY6rlmm42MbpB5046pP3?e=90IZdy. Entering any number into the 'segment', cell F4, changes the values below in Tier 1 and 2, columns F and G. If the link doesn't work please let me know. The formula that I've tried in DAX is as follows: IF( SUM([Proposed Install Base Value]) * SUM('RIL-Stack 750E - CollectSeg'[Annual Usage]) > '5', CALCULATE( SUM( MAX( ROUNDUP( SUM([Proposed Install Base Value]) * SUM('RIL-Stack 750E - CollectSeg'[Annual Usage]) / (12)),0, SUM('RIL-Stack 750E - CollectSeg'[TTQ]) + SUM('RIL-Stack 750E - CollectSeg'[TTQ])) - (1)) + ROUNDUP( SUM( SUM( SUM([Proposed Install Base Value]) * SUM('RIL-Stack 750E - CollectSeg'[Annual Usage]) / 365) * SUM([Warehouse To Site Leadtime Value]),0) ) ) ),0 ) I appreciate any guidance on this. Like I said, I'm at a loss. Thanks. Will
