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.
The goal is to create a measure of the difference between any date on the Date column and 10/01/2020. I am getting an error on the first step...not sure why the calculation is not accepting the Date field.
The final result will look something like (but with the right syntaxes):
Days to 10/01/2020 = 'Daily Trend'[Date]-10/01/2020
Solved! Go to Solution.
@diogobraga2 - Try:
Days to 10/01/2020 = (DATE(2020,10,1) - 'Daily Trend'[Date]) * 1.
Or
Days to 10/01/2020 = (DATE(2020,10,1) - MAX('Daily Trend'[Date])) * 1.
HI @diogobraga2
I would use datediff https://docs.microsoft.com/en-us/dax/datediff-function-dax
ColumnDiff = DATEDIFF('Daily Trend'[Date] ), DATE(2020,01,10), DAY )
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@diogobraga2 - Try:
Days to 10/01/2020 = (DATE(2020,10,1) - 'Daily Trend'[Date]) * 1.
Or
Days to 10/01/2020 = (DATE(2020,10,1) - MAX('Daily Trend'[Date])) * 1.
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 |
---|---|
113 | |
103 | |
77 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |