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,
I want to display the last order date for tag id with in selected date range.
Figure 1: Month MAY
Month : April
with respective of the selected month, should show only one record in a month for a Tag ID's
Please advice , measure or calculated column.
Hi @NavaneethaRaju ,
Just write a max measure.
LastOD= max(table[Order Date])
If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.
Thanks and Regards,
Atma.
Hi @Dhacd ,
I used your measure its working fine. thank you.
And one more issue, i want to show the account name. while using account name from separate table(Account Dim) again its showing all the dates and data.
Actutally it should show only these marked three.
This is the relationship, Please advice as soon as you can.
Is the bidirectional relationship required there for any reason?
can you try changing the flow from account details to the fact table?
Regards,
Atma.
Hi @Dhacd ,
I tried both and single directional, its not showing exactly on that date which account has used. is there any way to find the dynamic ranking - like respective of selected date which the max order date, we ranking from 1 to end and can we apply filter 1 in visual level.
I have a idea, but i'm not good in ranking measures.
@NavaneethaRaju
You can restrict it with measures. If it is okay can you share the pbix by using wetransfer.com
So that I can take a look.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |