Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Details:
Hi
I need value for for Bulk Geocoder row :
this value needs to calculated by summing up two entries coming from CPM View Extract(2) table , look for last column values, if we sum these two values, then that will be the value for AWS sum table Bulk Geocoder entry
How to sum these two entry value from CPM View Extract(2) table and assign it to the single entry Bulk Geocoder in AWS Sum table.
Pls help
Solved! Go to Solution.
Hi @Asha_2021 ,
Based on my understanding,you could create a calculated column similarly as below:
Column =
SWITCH (
'Table'[Application name ],
"bulk geocoder",
SUMX (
FILTER ( 'Table (2)', 'Table (2)'[Ord Application name ] = "e" ),
'Table (2)'[value1]
)
+ SUMX (
FILTER ( 'Table (2)', 'Table (2)'[Ord Application name ] = "f" ),
'Table (2)'[value1]
)
)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hi @Asha_2021 ,
Based on my understanding,you could create a calculated column similarly as below:
Column =
SWITCH (
'Table'[Application name ],
"bulk geocoder",
SUMX (
FILTER ( 'Table (2)', 'Table (2)'[Ord Application name ] = "e" ),
'Table (2)'[value1]
)
+ SUMX (
FILTER ( 'Table (2)', 'Table (2)'[Ord Application name ] = "f" ),
'Table (2)'[value1]
)
)
And you will see:
For the related .pbix file,pls see attached.
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
@Asha_2021 You mentione "last column values". What indicates that the column values are "last"?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.