Forum Discussion
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...
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
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
Hi Dedmon....
Can you kindly have a look at this question please.
https://community.powerbi.com/t5/Desktop/Add-values-Via-a-Measure-to-a-Specific-Date/m-p/1765401