Forum Discussion
Transformation with the help of SQL query
Hello, I have a small problem with PBI. I have 2 tables namely 'Salesforcemerge' which contains Subscriber Number, Term Start Date, TermEnd Date, etc, and 'UsageFullAgg ' which contains Subscr...
Anonymous
You can only implement these step by step, there are different methods, a short guide:1. Group by in the Query Editor
2. Inner Join
3. Create a Distinct table when A.name='S75000001749', for example:
Table = CALCULATETABLE(DISTINCT('Tablename'[Columnname]),FILTER('Tablename',[A.name]='S75000001749'))
4. For the conditional sum expression, you can create a column using DAX with IF function also there is a REPLACE function.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Anonymous
You can only implement these step by step, there are different methods, a short guide:
1. Group by in the Query Editor
2. Inner Join
3. Create a Distinct table when A.name='S75000001749', for example:
Table = CALCULATETABLE(DISTINCT('Tablename'[Columnname]),FILTER('Tablename',[A.name]='S75000001749'))
4. For the conditional sum expression, you can create a column using DAX with IF function also there is a REPLACE function.
4. For the conditional sum expression, you can create a column using DAX with IF function also there is a REPLACE function.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.