Also note that I talk about a lastUpdated here and in the next code block, this was added since taking the screenshots above. Note that the table names in PowerBI differ from those in the SQL Database, but that is in no way affecting it as I am rewriting to the proper layout in code. I am completely clueless on what functions I can still try and how from the plethora I've already tried. In SQL Server I have a fully working query to get the proper result, but I cannot replicate it into the PowerBI DAX Meassures. An example of this behaviour can be seen in this image wherein the 2nd from the top is an updated duplicate of the first one as referenced by their IDs:Īs I see no sensible way that PowerBI can help me prevent this just page or visual level filters (TOPN doesnt do the trick as the duplicate of the 1st would nigh always have a more recent date than say the 10th entry) I decided to look into Meassures to generate a custom table that way but for the life of me I cannot at all get it figured out. status going from 'OPEN' to 'CLOSED') however when this change happens PowerBI sees it as an entirely new entry and rather than updating the previous one it fills a duplicate into the table. ![]() This view properly filters out changes to any of its entries (i.e. For my business I have some latest incidents that I push to PowerBI from a view in an Azure SQL Database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |