I would like to create a column with flag 1 or 0 based on two date columns. Here is the sample data:
I want to take the max of month first. So in this case, it will be 2/5/2019 with two modified dates, then I have to take the max of modified date. So final output should be something like this:
|KPI Name||Month||Modified||Is Latest|
Only the last row should be returned.
I tried a couple of dax queries and it doesnt yield the result I want. Can someone help ?
Solved! Go to Solution.