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 there,
I have two tables, one called location and other table is called transactions which has transaction count, trnasaction is linked to Location table on location key.
Location table has two measures to calculate date range, Start Date and End Date (these are measures get calculated based on some business logic)
Now I want to calculate sum of transaction from transaction table where transaction date is between Loation start and end date (measures) and here is what I tried.
MTD New = CALCULATE(SUM('Transaction'[Transaction Count]), DATESBETWEEN('Transaction'[Tran Date], [m MTD Location Start Date Current], [m MTD Location End Date Current]))
Issues:
1. I added a table, added location key and MTD New Measure, I get correct values for MTD New but total at the bottom is totally different.
2. If I put MTD New as card, i don't get correct sum.
Not sure what I'm doing wrong here, any help will be appreciated.
PS - Location date range start and end date is a measure not a column and I'm thinking it has something to do with my calculation.
Thanks,
P
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Try:
measure = SUMX ( VALUES ( Location[Location key] ), [MTD New] )
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |