March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hai All, I need your support on this
Scenario: I working on a sales report,
In the Version (top) you can see the latest version and the bottom red line(previous version)
I want to create a dynamic title based on these
The output should be dynamic For eg: The latest version is V6-June-2021 And the Previous Is V5-May-2021
So I want to set a dynamic title based on these versions
Output = Sales Forecast Trend by Volume -[V6-June-2021 vs V5-May-2021]
If the user sends a new version next month(V7-July-2021) so the output should be [V7-June-2021 vs V6-June-2021]
Thanks
Alan
Note: In this table has a column called forecast version
So every month if new version appended in this column will reflect
Thanks for the solution, but could you please mention the Dax to create a dynamic title based on a measure which you created now
output
Sales Forecast Trend by Volume -[V6-June-2021 vs V5-May-2021]
Create a new column in DAX (on in power query)
Date = datevalue(right([version], len([version]-1) )
Now create a rank
Rank = rankx(Table, [Date],,desc, dense)
now
flag for latest
if([Rank] =1 1, "Latest", [Rank])
these column can be used Rank can also used to find by adding +1
refer examples, I have used -1 as I have desc rank (Custom Period)
DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
125 | |
85 | |
69 | |
54 | |
45 |
User | Count |
---|---|
204 | |
105 | |
98 | |
65 | |
54 |