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
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
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |