The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to analyse bunch of budgets for clients that gets updated as needed but ultimalty keep a table would host only the latest budget information, I thought of doing it this way which is indeed keeping the latest day approved but then the other data gets messed up.. any advise
let
Source = #"Budgets ALL",
#"Grouped Rows" = Table.Group(Source, {"Medicaid ID Number:"}, {{"LatestRow", each Table.Max(_, "Transmittal Date:"), type record}}),
#"Expanded LatestRow" = Table.ExpandRecordColumn(#"Grouped Rows", "LatestRow", {"Name", "Individual Name", "Annual Budget Effective Date:", "Transmittal Date:", ..})
in
#"Expanded LatestRow"
Solved! Go to Solution.
Hi I think try these steps
Hi @frenchy988
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi @frenchy988
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi @frenchy988
I wanted to follow up and ask if you have tried the steps provided by @Akash_Varuna . Could you please confirm whether your query has been resolved? If not, please share detailed information about the issue you are facing so that we can better understand it and provide you with a possible solution. If your issue has been resolved, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.
Thank you!
Hi @frenchy988, what do you mean with "but then the other data gets messed up"?
Hi I think try these steps