Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have two columns. COL A has account name(Where the same account name can show up multiple times) and COL B has Earliest Create date.
How do I show only the earliest date by Unique Account? I only need to see the first created date by account.
Thanks,
Solved! Go to Solution.
hi @Anonymous
try
measure = calculate(min(Table[Date]), allexcept(Table, Table[account name]))
Hi @Anonymous ,
You can try the measure below:
measure = CALCULATE(MIN('Table'[Date]),FILTER(ALL('Table'),'Table'[Account name] = MAX('Table'[Account name])))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
hi @Anonymous
try
measure = calculate(min(Table[Date]), allexcept(Table, Table[account name]))
How in the heck did this get translated to spanish and posted in the spanish forum....
fortunately I can read, but this is odd.
Hi AZ,
This worked great. Thank you.
Thanks,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |