Power Bi, Dax Syntax to subtract TODAY date with criteria from a column with repeated dates
The problem is, I have table with products, their "adresses" and the expiration date, just like below:
I need to show the "days to expire" in a matrix-visual so I tried to make a DAX formula as it goes trying to get the "days to expire" from each product and it's expiration date uniquely, but the result was way far from what i wanted.
DaysToExpire = CONVERT(SUM(Venda_Abast_Venc[DTVALIDADE]) - TODAY(), INTEGER)
It resulted in the sum of all the expirations dates by product and subtracted by the Today() date, the number was really higher than the real value when I needed it uniquely.
Solution
This is fairly straight forward, add a new column:
DaysToExpire = DateDiff(Today(), Venda_Abast_Venc[DTVALIDADE], DAY)
- Adding time from a string to a Java date: too little is added
- Format of Date in the JavaFX.TableView
- SimpleDateFormat ignores "XXX" if timezone is set to "UTC"
- Invalid date in safari
- Java: epoch date to MM/DD/YYYY
- how to construct and write a formula to google sheets to perform a dynamic date calculation
- If I wanted to work using dates and time going millions of years into the past/future how would I do it?
- Epoch to Date Not Working Properly
- What is going wrong in this target date calculater?
- Error using SimpleDateFormat
- How to calculate number of days between dates?
- Is `new Date(string)` reliable in modern browsers, assuming the input is a full ISO 8601 string?
- Subtract/Add days to a predefined date using Write-Host
- java.text.ParseException: Unparseable date: Mon Apr 08 00:00:00 IST 2013
- How to solve java.text.ParseException: Unparseable date?
- How to parse a date string in a foreign language with go time
- java.text.ParseException: Unparseable date: "2014-06-10T13:37:17.744Z"
- Google Sheets Script new Date() with timezone is providing wrong time
- UnParseable Date Exception :"2015-02-06T16:05:20"
- Error by converting date: Unparseable date in JAVA
- Pandas read_sql_query - date params
- java.text.ParseException: Unparseable date Exception while converting timestamp value to time in java
- DATEDIFF vs (w1.date = w2.date +1) difference? MySQL syntax
- React > PrimeReact > DataTable > Date Filter - Strip Timezone?
- Obtaining last Friday's date
- Using DateFormat with locale causes FormatException: Trying to read yyyy from 2020-08-07 15:00 at position 0
- Convert local time (GMT+8) to UTC time
- Spark Window Functions - rangeBetween dates
- Convert between LocalDate and sql.Date
- Find total length of time in multiple values of a dataset that overlaps with a given period of time