Calculating quote ages
Hello, I have a data set with month and count of quotes. I need a measure that will calculate Count the number of quotes that are: current (1 - 4 months); 5 - 7 months old; 8 - 12months old and greater than 12 months old based off today's current month. An example of what I want is below. I will then put the measures into a bar chart to see the "age" of the quotes. TIA
DATESBETWEEN is not working with min and max dates
I am trying to select a date (or several dates) in my slicer, and then use this to calculate a range of dates from 5 days prior to the earliest date selected to the max date in the slicer. For example, selecting 10th Feb in the slicer should give me a date range from 5th Feb to 10th Feb. I've created two calculated columns for these: MinDatePeriodMX = CALCULATE(min('Period A'[Day_Date])-5) MaxDatePeriodMX = CALCULATE(max('Period A'[Day_Date])) They seem to work as expected. However, I can't use them in conjunction with this formula: # Users - L13W MX = CALCULATE([# Users], DATESBETWEEN('Period A'[Day_Date], [MinDatePeriodMX], [MaxDatePeriodMX])) Instead of returning the # Users measure for only the dats in red below, it returns either only the date(s) in the slicer or if i disable interactions from the slicer, then it returns all dates there is data for. I only want the range of dates in the red box above. How do I achieve this? If I change the formula to "hardcode" the dates then it does work as expected: # Users - L13W = CALCULATE([# Users], DATESBETWEEN('Period A'[Day_Date], "2023-02-05", "2023-02-10")) Which makes me think that I'm missing some context somewhere. But I can't for the life of me work out where.
Find duplicates between "date selected" and "date selected" - 30 days
Hi! 🙂 I have date filters (slicer) for year, month and day in a model that uses a table with [ID] and [Date] I want to show the duplicates between the "Date selected" and ("Date selected" -30 days) This is the table: If i select "December 1st, 2022" it should only show these: Thank you!
How to count working days between two dates within the same table
Hi everyone, I am attempting to create a measure per row which counts the working days between two days within the same table. To do that, I found the following guide: https://blog.enterprisedna.co/calculate-workdays-between-two-dates-in-power-bi/ However, when I follow it, I get the error message "A single value for column 'DateOfDelivery' in table 'Deliveries' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.". Unfortunately, I am unsure how to address this problem adequately. The way I see it, there is always just one 'DateOfDelivery' per row so I do not understand how this single value cannot be determined per row. Here is the table that I am using: Here, it is possible that one order may result in several deliveries. And this is my date table: I am using the following DAX expression: PassedDays1 = CALCULATE( COUNTROWS('Date'), DATESBETWEEN( 'Date'[Date], Deliveries[DateOfDelivery], Deliveries[OrderDate] ), 'Date'[IsWeekday] = TRUE ) Does anyone know what/where my error is?
