Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I need to exclude rows based on min date from the table. Also, it should be dynamic.
Please find the below sample data
Date A B C D
16-AUG-2018 XAG/USD 0 0 14.4461
16-AUG-2018 XAU/USD 0 0 1175.26
17-AUG-2018 XAG/USD 0 0 14.6289
17-AUG-2018 XAU/USD 0 0 1173.52
20-AUG-2018 XAG/USD 0 0 114.675
21-AUG-2018 XAU/USD 0 0 1190.26
22-AUG-2018 XAG/USD 0 0 14.7713
My output is
17-AUG-2018 XAG/USD 0 0 14.6289
17-AUG-2018 XAU/USD 0 0 1173.52
20-AUG-2018 XAG/USD 0 0 114.675
21-AUG-2018 XAU/USD 0 0 1190.26
22-AUG-2018 XAG/USD 0 0 14.7713
Kindly help to resolve this. Thanks in advance
Solved! Go to Solution.
Hello @sakthi0311,
I guess while calculating measure that is used for D, you can filter the dates table by the following expression maybe:
FILTER(datestable,datestable[date]<>MIN(datestable[date])
What I suggest is if you can share the sample data, it would be better to solve your issue.
Regards.
Hello @sakthi0311,
I guess while calculating measure that is used for D, you can filter the dates table by the following expression maybe:
FILTER(datestable,datestable[date]<>MIN(datestable[date])
What I suggest is if you can share the sample data, it would be better to solve your issue.
Regards.
Hi,
I want to exclude rows which has min date from the table.
Please find the sample data below. The date can get add. In that I need to remove min date dynamically.
Date A B C D
16-AUG-2018 XAG/USD 0 0 14.4461
16-AUG-2018 XAU/USD 0 0 1175.26
17-AUG-2018 XAG/USD 0 0 14.6289
21-AUG-2018 XAU/USD 0 0 1190.26
22-AUG-2018 XAG/USD 0 0 14.7713
22-AUG-2018 XAU/USD 0 0 1195.86
My output should be
Date A B C D
17-AUG-2018 XAG/USD 0 0 14.6289
21-AUG-2018 XAU/USD 0 0 1190.26
22-AUG-2018 XAG/USD 0 0 14.7713
22-AUG-2018 XAU/USD 0 0 1195.86
If anyone has idea please help. Thanks in advance.
Can you please share your sample pbix file with sample data?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |