Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be 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

Reply
AlanP514
Helper V
Helper V

Dynamic Title Based on versions

Hai All, I need your support on this 
Scenario: I  working on a sales report,

AlanP514_0-1654670645449.png

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 

AlanP514_1-1654670978657.png

So every month if new version appended in this column will reflect

2 REPLIES 2
AlanP514
Helper V
Helper V

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]

amitchandak
Super User
Super User

@AlanP514 ,

 

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.