datepowerbidaxsubtraction
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)
- Detect daylight saving time in bash
- Comparing text fields that contain dates in Google Sheets
- java.util.Date vs java.sql.Date
- Find all month names between two given date in java
- vba return first row number in column that has todays date or nearest date after today
- Iterate over all last-day-of-the-month dates in a year
- How to set the current date in the gnuplot title
- How can I validate a date in Python 3.x?
- how to use str_to_date (MySQL) to parse two-digit year correctly
- Jquery dd/MM/yyyy date format validation
- Duration between two dates in Ruby (Rails)
- How to generate a Date from just Month and Year in Java?
- In Swift 5, how do I increment a date property by some interval and then run the function with that new future date?
- Last day of quarter
- Split timeperiods by referring dates in another table
- for loop to generate time list in javascript
- How to calculate difference between dates by group in SAS
- Why does DateTime.Now to the yyyy-mm-dd format give me incorrect month results?
- How to get current date and time in WordPress?
- Date change function in PHP
- Best approach to remove time part of datetime in SQL Server
- How to get year/month/day from a date object?
- How to update a field in React Hook Form based on other fields' values?
- How to check if there is a weekend between two dates in php?
- Get next day, skip weekends
- Check if one date is between two dates
- Trying to figure out why my GoogleSheets Date formula is not working
- How to turn everything from a per-year basis to a per-school-year basis?
- How to shorten the distance of two far apart date points in matplotlib?
- How to specify a TimeZone when creating a DateTime object in Dart/Flutter?