Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have multiple extract date in one month on my data set.
For my monthly reporting, I just need to pick the last extract date of every extract the month. How can I create a flag to only pick the last extract date of a month?
Thanks.
Cheers,
Kev
Solved! Go to Solution.
@BigKev ,
Just change the DAX like below:
Flag = If(Table[ExtractDate]=ENDOFMONTH(Table[ExtractDate]),1,0)
@BigKev ,
Create DAX like below:
Flag = If(Table[ExtractDate]=MAX(Table[ExtractDate]),1,0)
HI Tahreem24,
Thank you for the prompt response.
The Dax queries only give me the flag on the latest date, which is 12/10/20.
I need to have flag '1' on the last date for every extract month, as per in the port scr.
Cheers,
Kev
@BigKev ,
Just change the DAX like below:
Flag = If(Table[ExtractDate]=ENDOFMONTH(Table[ExtractDate]),1,0)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |