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.
I am trying to re write this query from POWER query using DAX and i cant figure out the syntax. can anyone point me in the right direction?
= Table.AddColumn(Source, "Custom", each if((Date.From([ACT_START_DATE]) <>"" ) and (Date.From([ACT_END_DATE]) = "") or
(Date.From([START_DATE]) <= Date.AddDays(Date.From(DateTime.LocalNow()),2))) then (Date.From(Date.AddDays([FINISH_DATE],-1))) else null)
Solved! Go to Solution.
try
New column =
IF (
( NOT ( ISBLANK ( 'Table'[start date] ) ) && ISBLANK ( 'Table'[End date] ) )
|| 'Table'[start date]
<= TODAY () + 2,
'Table'[End date] - 1
)
try
New column =
IF (
( NOT ( ISBLANK ( 'Table'[start date] ) ) && ISBLANK ( 'Table'[End date] ) )
|| 'Table'[start date]
<= TODAY () + 2,
'Table'[End 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 |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |