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.
I have a single table that contains both charges and payments tied to an Invoice #. The date field shows the date of the ledger transaction (be it charge or payment) I would like to create a calculated column that populates each record with the date of the charge. See below for what I'm trying to accomplish. Thank you, everyone, again, in advance, for your assistance.
Solved! Go to Solution.
Hi @pcuezze ,
We can use the following DAX query:
Date of Service = CALCULATE ( MIN ( 'Transaction Table'[Date of Trx] ), FILTER ( ALL ( 'Transaction Table' ), 'Transaction Table'[Invoice#] = EARLIER ( 'Transaction Table'[Invoice#] ) && 'Transaction Table'[Trx Type] = "Charge" ) )
The result will like below:
Best Regards,
Teige
Hi @pcuezze ,
We can use the following DAX query:
Date of Service = CALCULATE ( MIN ( 'Transaction Table'[Date of Trx] ), FILTER ( ALL ( 'Transaction Table' ), 'Transaction Table'[Invoice#] = EARLIER ( 'Transaction Table'[Invoice#] ) && 'Transaction Table'[Trx Type] = "Charge" ) )
The result will like below:
Best Regards,
Teige
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |