User Profile
chelynne
Regular Visitor
Joined 5 years ago
User Widgets
Contributions
Re: Bug? - IsInNextNMonths
My expected result. I want to see things expiring within the next 2 months, including this month as 2. I want to things expiring within the next year(it's now 15 June 22, so before 15 June 23) as 12, if nothing else has been written yet. Expected Result ^ 18, not 12. That date is not within the next 12 months... or do I need to change it to 11 months if it doesn't count the current month? This isn't super intuitive. New formula I'm trying. I changed the "2" line to --> else if Date.IsInNextNMonths([Security Expiry Date]), 2) or (Date.IsInCurrentMonth([Security Expiry Date]) and [Security Expiry Date] > DateTime.LocalNow) then "2"Bug? - IsInNextNMonths
I'm experiencing some very weird results with this powerquery formula. I know the formula is a bit janky, but it's not working as it should. 1st pic - formula, 2nd pic - weird result. June 26th is NOT within the next 12 months. 3rdpic - formula not properly populating a few of the results that do indeed have expiry dates.Refresh service dashboard with datasource being endpoint from on prem servers
Hey all, I am using an endpoint that allows me to bring in data from an on prem data source that isn't connected to open internet. This works just find in powerbi desktop with manual refresh, but I cannot get it to work for my powerbi online dashboard. Refresh fails every time no matter what I do. Issues I'm thinking it might be : this data source does not require credentials, also I've read elsewhere I might need to do the data gateway solution?? Can anyone help with this? Thanks
