Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I have 2 tables:
The first table (Sales Header) contains some basic information on order level. That means one row per order:
Then I have the Sales Details table, which contains several rows per order:
Now I would like to get just the last entry per order.
How would you do that using DAX Measures?
@Anonymous : Thanks, that works fine! What is, if a need a sub/ grand total? Then this measure will not work, right? I guess I need a countrows. How would you do that?
@joshua1990 From the visualization pane, go to the FORMAT of visual, and from there, you can keep the google buttons ON for subtotal. Pls, look at the Screenshots I have added.
Pls approve my reply and let me know if you have any further queries!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.