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.
I have a one row per person with details related to his loan start and end date, repayment and installment amount information, what I want to get is the balance as on date.
for example,
Person A got loan of $100 on 6/9/2023 which has installement amount of $8 then every month 6th the value should get updated with $100 - $8 and the values should be repeating for slicer selection till next month 6th is encountered. Shown in the image below.
The balance as on date is a measure and I have multiple tables and date dimension. I have tried different things nothing seems to work.
I ideally want to count every 6th of the month as one month and calculate the balance amount as on date for that particular month. Which is becoming tricky. Please help.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
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 |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |