Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have used the simple if command as below
Solved! Go to Solution.
It would be similar to
DATEDIFF(<start_date>, <end_date>, <interval>)
The interval is the units so it would be one of these
- SECOND
- MINUTE
- HOUR
- DAY
- WEEK
- MONTH
- QUARTER
- YEAR
Check it here https://docs.microsoft.com/en-us/dax/datediff-function-dax
You will need the Dax DATEDIFF function. I think you need to pass DAY as the third parameter.
I have just noticed that this question is in the Power Query forum but you wrote some DAX. That's OK but make sure you create the column in the right place.
thanks
I am very new in Power bi,
could you please tell me an example?
I couldn't understnd what the third argumnet is
thanks
It would be similar to
DATEDIFF(<start_date>, <end_date>, <interval>)
The interval is the units so it would be one of these
- SECOND
- MINUTE
- HOUR
- DAY
- WEEK
- MONTH
- QUARTER
- YEAR
Check it here https://docs.microsoft.com/en-us/dax/datediff-function-dax
I still have issue with the below formula
Thanks