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.
hi there ;
i need your kind support for below issue
i have a date typed column on query side , near this column i want to create a new column which includes 1 day earlier data then my date column
you can what i need as below wtih right new date column
thanks in advance
Solved! Go to Solution.
@erhan_79 , That was dax in M try like
New Date = [Date] -duration(1,0,0,0)
or
New Date = [Date] -#duration(1,0,0,0)
As a new column
new date = [Date] -1
i want to create a new column on the power query side , but when i add a custom column with below formula , it gives below error
@erhan_79 , That was dax in M try like
New Date = [Date] -duration(1,0,0,0)
or
New Date = [Date] -#duration(1,0,0,0)
HI @erhan_79
Create a column
New date = [date] - 1
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 |
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |