Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |