Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I need to calculate how many days gap each stock has until I see the first value, but I couldn't find a solution.
It has to take into account up to the first value it encounters.
Can you help me?
Thank you for your support.
To calculate the number of days until the first value for each stock, you can use a combination of DAX functions such as FILTER, MINX, and DATEDIFF. Try this:
Days Until First Value =
VAR FirstValueDate = MINX(FILTER(StockData, [Value] <> BLANK()), [Date])
RETURN IF(ISBLANK(FirstValueDate), BLANK(), DATEDIFF(StockData[Date], FirstValueDate, DAY))
Unfortunately it doesn't work.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |