Forum Discussion

homelander123's avatar
homelander123
Helper I
1 year ago
Solved

Dynamic name

CurrentMonthLastYearCount = VAR SelectedMonth = MAX(Query1[SetupDate]) VAR LastYearSameMonthStart = EOMONTH(SelectedMonth, -13) + 1 VAR LastYearSameMonthEnd = EOMONTH(SelectedMonth, -12) VAR Resu...
"DAX " "DAX help" 'Need help'
"DAX " "DAX help" 'Need help' 'DAX'
"DAX Commands and Tips"
"DAX help"
"DAX help" DAX
"DAX Query View"
  • Anonymous's avatar
    Anonymous
    1 year ago

    Your solution is so great Punithurs and lbendlin 

    Hi, homelander123 

    I think you can refer to this blog post from the community below:

    Dynamic titles in Power BI - Microsoft Fabric Community

     

     

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

lbendlin's avatar
lbendlin
Super User
1 year ago
CurrentMonthLastYearCount =
CALCULATE( SUM(Query1[NewCount]), SAMEPERIODLASTYEAR(Dates[Date]))

This assumes that you have a proper calendar table "Dates"  is your data model.