Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to use variable while creating table?

Hi,  I am having problem while trying to create new MonthlyData summary table.  I am using the function below which gives me what I want however I would have to manualy update the value 18 every we...
Tutorial Requests
  • sayaliredij's avatar
    sayaliredij
    5 years ago

    You can try following DAX Code

     

    MonthlyData =

    var CurrentFW = CALCULATE(MAX([FiscalWeek]), FILTER(ALL('Epiphany TimeTable'),'Epiphany TimeTable'[Date] =TODAY()))

    var result = 
    ADDCOLUMNS(
    SUMMARIZE(WeeklyData, WeeklyData[FiscalMonth]),
    "LYNetRevenue",CALCULATE(SUM(WeeklyData[LYNetRevenue]), WeeklyData[FiscalWeek] < CurrentFW ),
    "TYNetRevenue",CALCULATE(SUM(WeeklyData[TYNetRevenue]), WeeklyData[FiscalWeek] < CurrentFW ))

    RETURN
    result

     

    Regards,

    Sayali

tchristy99's avatar
tchristy99
Helper II
5 years ago

Hi,

 

To declare a variable you would simply write the following:

 

VAR variableName = "Variable Value"

 

RETURN

 

variableName //The calculation you want to return