Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to filter out debit and credits from table, either in power query or dax formula (both if all possible).
Any suggestions? If the transaction was refunded entirely (Yellow highlight), i want to filter it off the report. If it was a partial refund (green highlight) or not refunded, i want to see it.
Please help.
@Coryanthony , create a new column and use that
new col =
var _cnt = countx(filter(Table, [employee ID] = earlier([employee ID] ) && [vendor] = earlier([vendor] ) && [Transaction Amount] = -1* earlier([Transaction Amount] )), [Transaction Amount])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s
return if(isbalnk(_cnt), 0,1)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |