Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Revising Formula for MoM %

Hi,   I would like to ask if is there a way to revise MoM% by excluding future month in the calculation?   As of writing, the month today August and PBI is already showing September. Please note ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Anonymous,

    Current dax expression are based on aggarede row context, you cna fix then to static result except you use static value as conditions.(power bi not include historical data feature)
    For this scenario, you can create a custom table with values that extract and reference in the dax expressions. The formula result will be fixed until you change on the parameter table.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Anonymous,

Current dax expression are based on aggarede row context, you cna fix then to static result except you use static value as conditions.(power bi not include historical data feature)
For this scenario, you can create a custom table with values that extract and reference in the dax expressions. The formula result will be fixed until you change on the parameter table.

Regards,

Xiaoxin Sheng