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 folks,
Need some help on this one!
I'm trying to map the amount against name by date preference between two tables.
For e.g. tables sale_data & Master_ID is connected on alias/Name (many to one relationship).
I need amount 2100 (as this is the amount aginst latest date) from table sale_data mapped to master_id table.
Moreover, the same should be available as column in data view.
Please feel free to reach out to me in case any more clarification is required.
Regards,
Saurabh Kedia
Solved! Go to Solution.
You don't want to get the result by creating measures,right? Maybe you may try to use 'Group by' function in Query Editor and then use 'Merge Queries' to get the table as requested.
Regards,
Cherie
You may add a rank measure first. Then you can get the latest amount as below:
Rank = RANKX ( ALLEXCEPT ( Sale, Sale[Alias] ), CALCULATE ( MAX ( Sale[date] ) ) )
LatestAmount = CALCULATE ( SUM ( Sale[amount] ), FILTER ( Sale, [Rank] = 1 ) )
Regards,
Cherie
Hi Cherch,
Thanks a lot for your inputs!
Actually, I knew this method.
I was to find a way to directly get the desired value.
Regards,
Saurabh
You don't want to get the result by creating measures,right? Maybe you may try to use 'Group by' function in Query Editor and then use 'Merge Queries' to get the table as requested.
Regards,
Cherie
Hi Cherch,
Thanks for you inputs.
Regards,
Saurabh
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 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |