Forum Discussion
NavaneethaRaju
Helper IV
Helper IVNeed help with Dax.
Hi,
I'm facing the issue with dax,
I wrote a measure that giving last order date respective of particular tag id.
meanwhile using order id from the tag table, its returning all the order id's. But actually it should return only one Order ID, which would be the last order date based on my measure.
Max OrderDate = MAXX(FILTER('Tag Usage Fact','Tag Usage Fact'[Tag ID]='Consignment Fact'[Tag ID]),'Tag Usage Fact'[Date DD/MM/YYYY]).
similarly when there are different order owners the date records repeat for every different order owner. Bit it should be ideally showing just one record.
also this is whah happens when we show account name from account table
also this is whah happens when we show account name from account table
Actually my result should be as shown below but including the above 3 mentioned columns.
7 Replies
- amitchandak
Super User
NavaneethaRaju , Not very clear.
This shoudl be code of new column and you can add conditions
Max OrderDate = MAXX(FILTER('Tag Usage Fact','Tag Usage Fact'[Tag ID]='Consignment Fact'[Tag ID] && 'Tag Usage Fact'[Owner]='Consignment Fact'[Owner]
),'Tag Usage Fact'[Date DD/MM/YYYY])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.- NavaneethaRaju
Hi amitchandak ,
I unable to upload the file here, can you sent your email id, so i can share the files.
- NavaneethaRaju
Account_DIM
Account ID Account Name 4954 Rockingham Memorial Hospital - TD 5253 Lewis-Gale Medical Ctr. - HCA 5667 Sentara CarePlex Hospital - SJ 6064 Baptist Med Ctr South - Montgomery AL 9637 Sentara Williamsburg Regional Medical Center
TAG FactOrder Date Tag ID Order ID Tag Owner Name Order Owner Name 28-10-2020 00:00 4 1479-201027-1 Brannon Wyatt Brannon Wyatt 01-12-2020 00:00 4 1479-201201-1 Brannon Wyatt Brannon Wyatt 15-12-2020 00:00 4 1479-201214-1 Brannon Wyatt Brannon Wyatt 31-12-2020 00:00 4 1479-201231-2 Brannon Wyatt Brannon Wyatt 21-01-2021 00:00 4 1479-210121-3 Brannon Wyatt Brannon Wyatt 02-02-2021 00:00 4 1479-210202-3 Brannon Wyatt Brannon Wyatt 06-04-2021 00:00 4 1479-210406-1 Brannon Wyatt Brannon Wyatt 20-04-2021 00:00 4 1479-210420-2 Brannon Wyatt Brannon Wyatt 11-05-2021 00:00 4 1479-210511-2 Brannon Wyatt Brannon Wyatt 27-05-2021 00:00 4 1479-210527-3 Brannon Wyatt Brannon Wyatt 04-11-2021 00:00 4 1479-211104-2 Brannon Wyatt Brannon Wyatt 30-11-2021 00:00 4 1479-211130-2 Brannon Wyatt Brannon Wyatt 15-03-2022 00:00 4 3292-220315-1 Brannon Wyatt Grant Noel 12-04-2022 00:00 4 1479-220412-3 Brannon Wyatt Brannon Wyatt 14-04-2022 00:00 4 1479-220414-3 Brannon Wyatt Brannon Wyatt 05-10-2021 00:00 5 3364-211005-1 Inactive - Laura Hamilton Angelos Mihalitsianos/David Turchin 04-08-2021 00:00 7 2014-210804-1 Jake Varadian William Schell/Andrew Frazier 09-09-2020 00:00 29 2029-200909-1 Sky Surgical Sky Surgical 24-09-2020 00:00 29 2029-200924-1 Sky Surgical Sky Surgical 24-09-2020 00:00 29 GM528538 Sky Surgical Sky Surgical 20-10-2020 00:00 29 2029-201019-4 Sky Surgical Sky Surgical 21-10-2020 00:00 29 2029-201021-2 Sky Surgical Sky Surgical 26-10-2020 00:00 29 2029-201026-1 Sky Surgical Sky Surgical 04-11-2020 00:00 29 2029-201104-1 Sky Surgical Sky Surgical 04-11-2020 00:00 29 2029-201104-2 Sky Surgical Sky Surgical 11-11-2020 00:00 29 2029-201111-2 Sky Surgical Sky Surgical 24-11-2020 00:00 29 2029-201124-1 Sky Surgical Sky Surgical 09-12-2020 00:00 29 2029-201209-1 Sky Surgical Sky Surgical 10-12-2020 00:00 29 2029-201210-1 Sky Surgical Sky Surgical 28-12-2020 00:00 29 2029-201228-2 Sky Surgical Sky Surgical 29-12-2020 00:00 29 2029-201229-1 Sky Surgical Sky Surgical 13-01-2021 00:00 29 2029-210113-1 Sky Surgical Sky Surgical 15-01-2021 00:00 29 2029-210115-1 Sky Surgical Sky Surgical 20-01-2021 00:00 29 2029-210120-1 Sky Surgical Sky Surgical 25-01-2021 00:00 29 2029-210125-1 Sky Surgical Sky Surgical 29-01-2021 00:00 29 2029-210129-1 Sky Surgical Sky Surgical 05-02-2021 00:00 29 2029-210205-1 Sky Surgical Sky Surgical 10-02-2021 00:00 29 2029-210210-1 Sky Surgical Sky Surgical 11-02-2021 00:00 29 2029-210211-1 Sky Surgical Sky Surgical 17-02-2021 00:00 29 2029-210217-2 Sky Surgical Sky Surgical 08-03-2021 00:00 29 2029-210308-2 Sky Surgical Sky Surgical 11-03-2021 00:00 29 2029-210311-2 Sky Surgical Sky Surgical 31-03-2021 00:00 29 2029-210331-1 Sky Surgical Sky Surgical 02-04-2021 00:00 29 2029-210402-1 Sky Surgical Sky Surgical 05-04-2021 00:00 29 2029-210405-1 Sky Surgical Sky Surgical 06-04-2021 00:00 29 2029-210406-1 Sky Surgical Sky Surgical 07-04-2021 00:00 29 2029-210407-1 Sky Surgical Sky Surgical 08-04-2021 00:00 29 2029-210408-1 Sky Surgical Sky Surgical 14-04-2021 00:00 29 2029-210414-1 Sky Surgical Sky Surgical 28-04-2021 00:00 29 2029-210428-1 Sky Surgical Sky Surgical 30-04-2021 00:00 29 2029-210430-1 Sky Surgical Sky Surgical 05-05-2021 00:00 29 2029-210505-1 Sky Surgical Sky Surgical 10-05-2021 00:00 29 2029-210510-1 Sky Surgical Sky Surgical 14-05-2021 00:00 29 2029-210514-2 Sky Surgical Sky Surgical 14-05-2021 00:00 29 2029-210514-3 Sky Surgical Sky Surgical 03-06-2021 00:00 29 2029-210603-2 Sky Surgical Sky Surgical 03-06-2021 00:00 29 2029-210603-3 Sky Surgical Sky Surgical 04-06-2021 00:00 29 2029-210604-1 Sky Surgical Sky Surgical 09-06-2021 00:00 29 2029-210609-1 Sky Surgical Sky Surgical 14-06-2021 00:00 29 2029-210614-3 Sky Surgical Sky Surgical 15-06-2021 00:00 29 2029-210615-1 Sky Surgical Sky Surgical 16-06-2021 00:00 29 2029-210616-1 Sky Surgical Sky Surgical 22-06-2021 00:00 29 2029-210622-1 Sky Surgical Sky Surgical 23-06-2021 00:00 29 2029-210623-1 Sky Surgical Sky Surgical 01-07-2021 00:00 29 2029-210701-3 Sky Surgical Sky Surgical 07-07-2021 00:00 29 2029-210707-1 Sky Surgical Sky Surgical 14-07-2021 00:00 29 2029-210714-1 Sky Surgical Sky Surgical 16-07-2021 00:00 29 467-210715-3 Sky Surgical Sky Surgical 29-07-2021 00:00 29 2029-210729-1 Sky Surgical Sky Surgical 04-08-2021 00:00 29 2029-210804-2 Sky Surgical Sky Surgical 16-08-2021 00:00 29 2029-210816-1 Sky Surgical Sky Surgical 18-08-2021 00:00 29 2029-210818-1 Sky Surgical Sky Surgical 18-08-2021 00:00 29 2029-210818-2 Sky Surgical Sky Surgical 23-08-2021 00:00 29 467-210819-4 Sky Surgical Sky Surgical 01-09-2021 00:00 29 2029-210806-2 Sky Surgical Sky Surgical 08-09-2021 00:00 29 2029-210908-1 Sky Surgical Sky Surgical 17-09-2021 00:00 29 2029-210917-1 Sky Surgical Sky Surgical 29-09-2021 00:00 29 2029-210929-1 Sky Surgical Sky Surgical 06-10-2021 00:00 29 467-211006-2 Sky Surgical Sky Surgical 15-10-2021 00:00 29 2029-211015-1 Sky Surgical Sky Surgical 20-10-2021 00:00 29 467-211020-2 Sky Surgical Sky Surgical 21-10-2021 00:00 29 467-211021-3 Sky Surgical Sky Surgical 22-10-2021 00:00 29 467-211021-4 Sky Surgical Sky Surgical 25-10-2021 00:00 29 2029-211025-1 Sky Surgical Sky Surgical 27-10-2021 00:00 29 2029-211027-1 Sky Surgical Sky Surgical 03-11-2021 00:00 29 2029-211103-1 Sky Surgical Sky Surgical 03-11-2021 00:00 29 2029-211103-2 Sky Surgical Sky Surgical 29-11-2021 00:00 29 2029-211129-1 Sky Surgical Sky Surgical 08-12-2021 00:00 29 2029-211208-1 Sky Surgical Sky Surgical 13-12-2021 00:00 29 2029-211213-1 Sky Surgical Sky Surgical 17-12-2021 00:00 29 2029-211217-1 Sky Surgical Sky Surgical 30-12-2021 00:00 29 467-211229-2 Sky Surgical Sky Surgical 04-01-2022 00:00 29 2029-220104-1 Sky Surgical Sky Surgical 05-01-2022 00:00 29 2029-220105-1 Sky Surgical Sky Surgical 10-01-2022 00:00 29 2029-220107-1 Sky Surgical Sky Surgical 10-01-2022 00:00 29 2029-220110-1 Sky Surgical Sky Surgical 13-01-2022 00:00 29 2029-220113-2 Sky Surgical Sky Surgical 18-01-2022 00:00 29 2029-220118-1 Sky Surgical Sky Surgical 18-01-2022 00:00 29 2029-220118-2 Sky Surgical Sky Surgical 19-01-2022 00:00 29 2029-220119-1 Sky Surgical Sky Surgical 20-01-2022 00:00 29 2029-220120-2 Sky Surgical Sky Surgical 02-02-2022 00:00 29 5229395-220202-1 Sky Surgical Sky Surgical 02-02-2022 00:00 29 5229395-220202-2 Sky Surgical Sky Surgical 09-02-2022 00:00 29 5229395-220209-1 Sky Surgical Sky Surgical 02-03-2022 00:00 29 5229395-220302-1 Sky Surgical Sky Surgical 22-03-2022 00:00 29 5229395-220322-1 Sky Surgical Sky Surgical 23-03-2022 00:00 29 5229395-220323-1 Sky Surgical Sky Surgical 04-04-2022 00:00 29 2029-220404-1 Sky Surgical Sky Surgical 04-04-2022 00:00 29 5229395-220404-1 Sky Surgical Sky Surgical 18-04-2022 00:00 29 5229395-220418-2 Sky Surgical Sky Surgical 25-04-2022 00:00 29 5229395-220425-1 Sky Surgical Sky Surgical 02-05-2022 00:00 29 5229395-220502-1 Sky Surgical Sky Surgical 05-05-2022 00:00 29 5229395-220505-1 Sky Surgical Sky Surgical 24-05-2022 00:00 29 5229395-220524-1 Sky Surgical Sky Surgical 31-05-2022 00:00 29 5229395-220531-1 Sky Surgical Sky Surgical 01-06-2022 00:00 29 5229395-220601-1 Sky Surgical Sky Surgical 08-06-2022 00:00 29 5229395-220608-1 Sky Surgical Sky Surgical 16-06-2022 00:00 29 5229395-220616-1 Sky Surgical Sky Surgical Consignment Fact-
Tag ID Placement Date Return Date 1 07-12-2010 00:00 3 15-12-2009 00:00 17-02-2010 00:00 4 15-12-2009 00:00 07-04-2010 00:00 4 16-04-2010 00:00 15-05-2013 00:00 4 15-05-2013 00:00 03-09-2014 00:00 4 03-09-2014 00:00 01-10-2015 00:00 4 01-10-2015 00:00 03-10-2017 00:00 4 03-10-2017 00:00 19-02-2018 00:00 4 19-02-2018 00:00 25-06-2019 00:00 4 25-06-2019 00:00 7 15-12-2009 00:00 01-04-2010 00:00 7 16-04-2010 00:00 15-05-2013 00:00 7 15-05-2013 00:00 16-04-2014 00:00 7 16-04-2014 00:00 01-10-2015 00:00 7 01-10-2015 00:00 03-10-2017 00:00 7 03-10-2017 00:00 19-02-2018 00:00 7 19-02-2018 00:00 25-06-2019 00:00 9 15-12-2009 00:00 08-12-2011 00:00 9 08-12-2011 00:00 17-05-2013 00:00 9 17-05-2013 00:00 15-06-2016 00:00 9 15-06-2016 00:00 30-05-2020 00:00 9 03-09-2020 00:00 22-09-2021 00:00 9 22-09-2021 00:00 22-09-2021 00:00 29 15-12-2009 00:00 31-03-2010 00:00 29 08-04-2010 00:00
Here i just enclosed tables.
