Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Good day,
Can pls someone help me how can i get the output i desire. I want the sum per article per project id.
Thank you
Solved! Go to Solution.
@AllanBerces Put Article No, Unit and Project ID_Article in a table visual. Add the sum of Quantity.
Or, if you want a calculated table:
Output Table = SUMMARIZE('Table', [Article No], [Unit], [Project ID_Article], "Unit", SUM('Table'[Unit]) )
@AllanBerces Put Article No, Unit and Project ID_Article in a table visual. Add the sum of Quantity.
Or, if you want a calculated table:
Output Table = SUMMARIZE('Table', [Article No], [Unit], [Project ID_Article], "Unit", SUM('Table'[Unit]) )