Calculate the number of days between today and specific date using DAX in Powerpivot
I have a date column in my data model. I want to calculate the # of days between today and the date in the column using DAX.
Thoughts?
Solution
You can create a calculated column with this formula:
=today()-[DATE]
and change the value of column in numeric:
- SQL Data: HTML Table display of column data containing multiple rows
- Excel: How to get a column of a related table into my worksheet?
- DAX CALCULATE does not respect Pivot Table row context
- Calculate the number of days between today and specific date using DAX in Powerpivot
- Calculate correct overall summary revenue in DAX
- Power Query: after combining 2 tables got something strange
- custom column to show a cell's value before combining files
- How to count if your column has the same values on another column in separate related table
- Sum of sales of delimiter column
- Convert table to reflect column names as row values
- PowerPivot extract text after different characters
- Power Query Copy Child Data to Parent in Hierarchy
- PowerPivot Relationships showing blank rows of data and not calculating the measures correctly
- Needs to Display date difference on X-Axis from the selected date slicer in PowerBI
- Refresh power pivot-power query
- PowerPivot Data Model Causing Cartesian Product
- How to get 'Sum' working in Calculated field based on another calculation?
- How to create a DAX formula to create another column based on the value in another column
- Excel DAX: Dynamically calculate the countof rows where each row's value is compared to the min value
- Retrieving data from DataModel (Power Pivot) within VBA
- Powerpivot data connection will not save the password
- PowerPivot - Average of column for a variable repeating for each row based on time period
- How to reuse a set of power query steps in another Excel document?
- Application-defined or object-defined error with Excel Slicer
- For Excel and PowerPivot, how to return more than 255 characters of text using CUBEVALUE?
- Alternative to network days for rotating shift patterns - DAX PowerPivot
- Calculate sum filter earlier DAX PowerPivot
- grouping consecutive dates of absence for each employee
- DAX Difference between columns in a one-to-many relationship
- How to password protect Power Query queries?