更新时间:2023-02-05 16:08:04
您好DD44P,
感谢您的提问。
如果您以非粗体格式输出,则可以添加计算列[差异]到输出表。所以DAX表达式是:
='YourTableName'[2019] - 'YourTableName'[2018]最诚挚的问候,
将
Hi,
I want a new measure to be added in my SSAS tabular model.
The output has to be like below:
Year 2018 2019 Difference
Status
Won 10 18 8
Lost 5 3 -2
I want to add the difference column when which will calculate the difference of Accounts won/lost in the selected years.
How can this be done?
Do I need two columns for this?
What will be the formula so that it takes the date filter and calculate the difference?
Please help.
Hi DD44P,
Thanks for your question.
If you have got the output in non-bold format, you could just add calculated column [Difference] to the output table. So the DAX expression is :
='YourTableName'[2019]-'YourTableName'[2018]Best Regards,
Will