Forum Discussion
DAX formula help!
| Stock | Average Stock Pendency | |
| Jan | 3000 | x |
| Feb | 4000 | x |
| Mar | 5000 | x |
| Apr | 3000 | x |
| May | 2000 | x |
| June | 5000 | x |
| July | 6000 | x |
......
an example if only one complaint existed
| Data criacao | data encerramento(closure) | time in stock end of january | time in stock end of february |
| 1/01/2021 | 1/03/2022 | 30 days | 60 days
|
and then i want to calculate the average time in stock (pendancy) for every month and year. in this case it would be 30 days in january and 60 days in february
Community Championlmcpinto OK, so I am not understanding how to get from your sample table of data to your expected output. It looks like you have a Month Column and a Stock column but I don't understand the "x"'s in the Average Stock Pendency column. Is that the average for all the rows in the table? The average for YTD? Or maybe something else? I also don't understand how you get to your second table that you posted. Is there a product involved here? What is in stock for 30 days, 60 days? I just don't understand what is going on here. If you can post a link to a sample PBIX file that might help tremendously.