Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Shorten DAX Formula

Hi Expert   I have the following DAX which i write VAR for each M period - how couldi possibly shorten the measure to something managable VAR M1 = Calculate([Running Total], Input[Year] = MonthY...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    Please try to use the following measure:

     

    M1+M2 = Calculate([Running Total],
Input[Year] = MonthYear &&

Input[Terms] = "BTMT" &&

Input[BB/FF] = "BB" &&

Input[Time Period No] ] = " &&

Input[BB] = Product &&
Input[M Column] IN{"M1","M2"})

     

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

     

    Best Regards,

    Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Amit - this is not working as i the value for each M value has to end up in the correct Month Column...in my matrix table...

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,What are you trying to achieve here. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.