Urgent !!! Query to Get latest status/value Using Dax/Power query
Hi Every one . I need help on beow requirement. Package rev needs to be sorted out in desc. I did this. However main requirement is need to get the latest status based on the PackageRev column. I have tried = CALCULATE ( MAX ( Merge1[PackageRev] ), FILTER ( Merge1, Merge1[Application version id] = EARLIER ( Merge1[Application version id] ) ) ) ) Measure2 = CALCULATE( VALUES(Merge1[Status]), ALLEXCEPT(Merge1, Merge1[Application version id]), FILTER( Merge1, 'Merge1'[PackageRev] = CALCULATE(MAX(Merge1[Packagerev]), ALLEXCEPT(Merge1, 'Merge1'[Application version id]) ) )) Column 2 = CALCULATE(MAX(Merge1[SortedColumn_new]), ALLEXCEPT(Merge1, Merge1[Application version id])) but these queries not giving exact results. Original data Expected data
Sqldatetime overlfow
Every now and then scheduled report refreshes fail with the following error: PBRS Refresh Error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. It looks like the report server cannot find the last processed date (Catalog modifiedDate?) or is returning an invalid datetime. The report refresh fails within a second, showing the error. To recover from this error the report needs to be downloaded and uploaded again, without making any modification. After that the refresh is working as expected. We are running on Power BI Report Server May 2022 on-prem. What could possibly be the issue / solution ?Do Business users have capability to upload the list of the column values to Power BI
End Users want to use self-service option out of the dataset that we built out of datawarehouse, does the users have the capability to upload a list of column values to be used as the primary selection criteria argument for the resulting report? Please give your suggestion.
