Power BI Desktop Dark Mode issue in Power Query

Anonymous

Not applicable

1 year ago

I can understand your frustration; however, I haven't encountered any issues in my current tests. Here’s my testing process:

My sample data is as follows:

1.Firstly, I used a custom column in Power Query to subtract two time columns.

2.Secondly, I employed a custom date subtraction function.

let
    DateDifference = (startDate as date, endDate as date) =>
    Duration.Days(endDate - startDate)
in
    DateDifference

Then, I used this date function to perform the subtraction.

3.Thirdly, I created a new query for date subtraction directly.

4.My current version is as follows:

We cannot rule out the possibility of a version issue, so I recommend upgrading your version according to your needs. Here’s the download link:

Of course, if I have misunderstood the date subtraction function you mentioned, please feel free to correct me.

I look forward to your reply.

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion