Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |