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.
Hello
In Power Query I want to create a custom column that returns a yes or no for the MAX load_timestamp for each given cardId.
|
Thank you in advance!
Solved! Go to Solution.
Hi @onernoa,
Firstly you need to click on the Data Icon on the left border and open the table in which you want to put the Desired Column.
Now, paste the DAX forumla into formula bar and click on the Tick Icon.
Desired Column =
var MaxTimestamp = CALCULATE (
MAX ( 'Table'[load_timestamp]),
ALLEXCEPT ( 'Table', 'Table'[cardId] )
)
var result = if( 'Table'[load_timestamp] = MaxTimestamp, "Yes", "No")
return result
If this answers your question, please mark it as a solution!
Hi @onernoa,
Firstly you need to click on the Data Icon on the left border and open the table in which you want to put the Desired Column.
Now, paste the DAX forumla into formula bar and click on the Tick Icon.
Desired Column =
var MaxTimestamp = CALCULATE (
MAX ( 'Table'[load_timestamp]),
ALLEXCEPT ( 'Table', 'Table'[cardId] )
)
var result = if( 'Table'[load_timestamp] = MaxTimestamp, "Yes", "No")
return result
If this answers your question, please mark it as a solution!
Many thanks. This has worked perfectly.
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |