Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculate formula

I have to calculate running total based on created date. I have one table where all the transaction is stored and other table has created date along with quarter. I used concatenate to create a key (...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    May be you just need to store the MEASURE value in a variable first

     

    Try this

     

    PQ_Rev_Test =
VAR myvalue = [DayOfPQ]
RETURN
    CALCULATE (
        [QTD],
        FILTER (
            ALL ( Revenue_Table ),
            Revenue_Table[Fiscal Quarter] = "FY18-Q3"
                && Revenue_Table[DayofQtr] <= myvalue
        )
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

May be you just need to store the MEASURE value in a variable first

 

Try this

 

PQ_Rev_Test =
VAR myvalue = [DayOfPQ]
RETURN
    CALCULATE (
        [QTD],
        FILTER (
            ALL ( Revenue_Table ),
            Revenue_Table[Fiscal Quarter] = "FY18-Q3"
                && Revenue_Table[DayofQtr] <= myvalue
        )
    )
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Zubair_Muhammad Thanks