Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, everyone.
I hope someone can help me with my poblem.
I have a table which have start date and end date rows (id, date_begin,date_end, amount).
I need to receive from it the amount and numbers of rows for a day or a few days (then I need to take notes that acted for at least one day for a period, but without duplicates).
The obvious way - to convert the start date and end date into one field and multiply the table entries. After the conversion, I got the opportunity to receive the amount and the number of rows per day and period ( count distinct), but there is the problem with amounts. Amount per day = sum(amount), but I dont't know how to get amount per period (the amounts are not unique, so I can't use sum distinct.
Please advise how to solve the problem.
Solved! Go to Solution.
You may try to use SUMMARIZE Function and SUMX Function.
You may try to use SUMMARIZE Function and SUMX Function.
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.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |