Forum Discussion

Kumshan450's avatar
Kumshan450
Helper III
8 years ago

DISTINCT TABLE USING DAX MEASURES

I have a file named receipt data with duplicates receipt no. Sample data   RECEIPT_NO BPIS_NO BPIS_VALUE_DATE C0597141800083 SBIN618127361534 07-May-18 C0476041801381 36867900 23-Apr...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

If you only have 1 Table, you do not need to create a seperate receipts table.  In a Table visual, i simply dragged the Receipt_No field.  I then wrote these two measures

 

Date = MIN(Data[BPIS_VALUE_DATE])

BPIS Number = FIRSTNONBLANK(Data[BPIS_NO],1)

 

Hope this helps.

 

Kumshan450's avatar
Kumshan450
Helper III
8 years ago

In this case i have two table 

 

One table contains the collection data. This also contains duplicate receipt no. 

 

Loan account no | receipt no | receipt date. 

 

Another table contains the receipt dump. Which i have shared in my earlier problem..

 

Purpose I have to create a relationship between the collection data and receipt dump/distinct receipt dump to find the difference between collection date and BPIS date. 

 

If i create table visual, I am not able to create any relationship between table visual data and the collection data.