Forum Discussion

Cali_2020's avatar
Cali_2020
Helper I
6 years ago

Separate date tables?

  Hello! I need some help regarding current and previous period dax expressions. In our organization, we analyze variances from the most recent forecast to the previous forecast, in which all is co...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Cali_2020,

You can use following calculate table formula to extract and summarize records from the sample data table:

Forecaste = SUMMARIZE('Table',[Forecast Date],[Forecast Name],"Forecasted Amount",SUM('Table'[Forecasted Amount]))

Regards,

Xiaoxin Sheng

Cali_2020's avatar
Cali_2020
Helper I
6 years ago

Hi Anonymous ,

 

Thanks for your reply but how can you use this formula with variables?

 

Thanks again!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Cali_2020,

    So you mean 'Forecasted Amount' is a measure formula that summarizes other table records? If this is a case, you can use measure formula in iterator functions to summarize function expression fields.

    BTW, current power bi does not support to create a dynamic calculated column/table based on filter or slicer. If you measure formula are dynamic based on filter, its result will be fixed in the calculated table formula.

    Regards,

    Xiaoxin Sheng