How to make a DAX calculation return BLANK rows
I'm working on a Power Bi template for my company. Since we are a global comapny i added Time Zone tables that help the end-user filter the visual for their Time Zone. Now I'm trying to create a DAX measure that will get the values in a DATE/TIME type column and sum the given UTC Offset in Hours, however I'm having a hard time when there's no value in a give row, DAX will just either not return the rows with blank or return the offset. What I'm trying to achieve is a function that will ignore the blank values and still return them, and when there is a value actually SUM the End Time UTC with the Offset. Note: [Current UTC Offset] is a measure that returns a decimal number from -12 to +12 How can i achieve this?
Display Two Different Dates from the same point on the X axis.
Hi, me again. I want to plot two lines that start from different dates in POWER BI. I have products that have a differents date of creation and i have to display the product since it launch on a line chart as X=0, so that my users get an understanding of how the respective product have fallen in delincuency product launch. This is what i currently have: This just a running total of the percentage of clients that fell into delincuency, but notice that both of these linnes start at different dates, they should star at point 0, measured by the numbers of weeks since the product launched. Sometihng like: Imagine that in the X axis we have numbers from 0 to whatever and that both start from 0, i just picked the two closest that i had. I'll leave a mockup file attached, product of previous help: https://drive.google.com/file/d/1uems6jCzxqkJHNdtcnXxxHxBo222XPB1/view?usp=drive_link
Return the Maximum count accordingfor past 3 years
I have a table called Safety Observations and counting the Safety Observations serial number and trying to return the maximum in each month for the past two years compare it with the current Year and add it in a trend line, as per the below image. For example, in January looking at the past 2 years - the maximum is in 2023 so it should return 30, meanwhile in February the maximum was in 2022 so I want to return 19. This is the Formula that i have used but its returning the 2024 . Max Per Year = CALCULATE (COUNT('Safety Observations'[SerialNo]) , FILTER ( ALL ( 'Date Dimension' ), 'Date Dimension'[Month] = MAX ( 'Date Dimension'[Month] ) ), DATESINPERIOD ( 'Date Dimension'[Date].[Date], LAST DATE ( 'Date Dimension'[Date].[Date] ), -2, YEAR ) ) Appreciate your guidance
Filter a DAX measure with dynamic date filters / Time Intelligence
I need to filter a calculated table to find the metric for a particular department of goods and a dynamic date range. The Sales Cycle should have a Sold % Quantity which is the total items sold divided by the number of items produced. These two numbers need to match: This DAX is not working: Sold % Qty Clothing = VAR _startSalesCycle = DATE(2024, 02, 04) VAR _endSalesCycle = DATE(2024, 02, 27) CALCULATE( [Sold % Qty], 'Production Units by Week'[DepartmentName] = "Donated Clothing", DATESINPERIOD(Dates[Date], _startSalesCycle, _endSalesCycle, DAY ) ) Eventually, I want the start and end of the Sales Cycle to determine how this table gets filtered on a weekly basis. Which date filters should I use?
