Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
EDIT:
Marked as new because of my last reply, asking for an additional column.
Thank you in advance 🙂
---------------------------------------
Dear BI heroes,
I have searched my question on forums and yourtube, but I just can't seem to get is right...
I have a table that looks something like this:
Customer | IngestionDate | Lincenses |
A | 10-3-2023 | 100 |
A | 11-3-2023 | 101 |
A | 12-3-2023 | 99 |
B | 13-3-2023 | 80 |
B | 14-3-2023 | 90 |
C | 16-3-2023 | 25 |
A | 15-4-2023 | 100 |
What I woul dlike to get in my PowerBi visual is the customer and per month the most recent value of licenses.
It should look something like this as a result:
Customer A | Licenses |
March | 99 |
April | 100 |
Customer B | |
March | 90 |
Customer C | |
March | 25 |
I do have a "Date" table with Month Name etc.
I do wanne know how to get the rows I want? the visual itself will be no problem 😛
Thank you in advance!
Solved! Go to Solution.
Hi Ahmed,
Thank you for your fast response, it is exactly what I asked for!
May I ask you a aditional question?
I would like the same result but with an extra licenses group:
Customer | IngestionDate | Lincenses_A | Lincenses_B |
A | 10-3-2023 | 100 | 20 |
A | 11-3-2023 | 101 | 25 |
A | 12-3-2023 | 99 | 24 |
B | 13-3-2023 | 80 | 50 |
B | 14-3-2023 | 90 | 53 |
C | 16-3-2023 | 25 | 101 |
A | 15-4-2023 | 100 | 19 |
Thank you in advance!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
76 | |
73 | |
42 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
42 |