Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |