New Member

10 years ago

Status:

Needs Votes

In Power Query, provide method to duplicate t-SQL DateDiff functionality

There is no clean, 100% correct way to derive Duration in Months or Quarters or Years in PowerQuery. We need one that respects 28/29/30/31-day months & leap years, similar to t-SQL DateDiff functionality

1 Comment

fbcideas_migusr
New Member
1 year ago
Status added:
Needs Votes

Recent ideas

Vertical Alignment of Header
In both Matrix and Table Visuals please add functionality to vertically align text. This functionality exists in Excel. Two exhibits below. First is current formatting options for The Matrix Visual...
BrandonHart
Advocate I
1 hour ago
New
226Views
7likes
2Comments
Workspace Sharing
In the past Power BI Admins had the ability to share a workspace as a whole with an external user to then initiate the invite email. After accessing their external account on our tenant, they could ...
MannyV1066
New Member
1 day ago
New
5Views
0likes
0Comments
Support SNC Authentication for SAP BW in Power BI Report Server
Organizations are increasingly moving toward encrypted and certificate-based authentication for SAP BW connections due to security and compliance requirements. Currently, Power BI Report Server (PBI...
Indramouli
New Member
1 day ago
New
6Views
0likes
0Comments
Dynamic Date Slicer
Hi Power BI Team, I’m really excited to see that the Date Picker options have reached General Availability in the August Power BI update. Thank you for continuously improving the product. One enhan...
CraftyCreator
Frequent Visitor
1 day ago
New
18Views
0likes
0Comments
How to remind the Global team to respond to ECNs with greater efficiency
Suggest Power BI send emails to each responsible person, and display how many days they have spent handling each ECN, compared to the required number of calendar days for completion.
richardzhu
New Member
1 day ago
New
36Views
5likes
2Comments