Forum Discussion
Shorten DAX Formula
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 , With your formula, Not sure where calculate is ending
Try this to merge
Input[M Column] in {"M1", "M2", "M3" ,//Add others
}
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...
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.
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