Forum Discussion

sid-agarwal's avatar
sid-agarwal
Frequent Visitor
1 year ago
Solved

PowerBI Datediff

I am trying to create data card on PBI report which shows the average time (in days) it takes to get the approval from the time the entry was created, which approval1Date Minus (-) the Create...
Need Help
Tutorial Requests
  • ahmedoye's avatar
    ahmedoye
    1 year ago

    Because you are creating this as a Measure and not as a Calculated Column, you may not get the right behavior.

    What you probably want to do is to create the formula as a calculated column, or use a Measure that is like:

    AVERAGEX(YourTable, DATEDIFF(YourTableColumn1, YourTableColumn2, DAY))

    If this works for you, kindly mark as answer to make it easier for anyone with similar issues to find the solution.

ahmedoye's avatar
ahmedoye
Responsive Resident
1 year ago

Because you are creating this as a Measure and not as a Calculated Column, you may not get the right behavior.

What you probably want to do is to create the formula as a calculated column, or use a Measure that is like:

AVERAGEX(YourTable, DATEDIFF(YourTableColumn1, YourTableColumn2, DAY))

If this works for you, kindly mark as answer to make it easier for anyone with similar issues to find the solution.