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.
Hi,
I have an application database that is designed the following way: (I cannot change it)
ID | TypeID | PropertyID | Date | Repeat Count | Amount |
1 | 1 | 1 | 2017-01-01 | 12 | 100 |
2 | 1 | 2 | 2017-01-01 | 1 | 35 |
3 | 1 | 1 | 2018-01-01 | 12 | 105 |
4 | 2 | 3 | 2017-01-05 | 1 | 500 |
1 | 1 | 1 | 2017-01-01 | 12 | 100 |
I need to be able to create a cash flow that can tell me by month, Property and type what the amount of that month is. I figured I need in a measure in a table that has all the months I need, but I am not sure how to do it.
Any help would be greatly appreciated it!
Thanks!
Solved! Go to Solution.
Here I found the answer to my problem. Thanks
Here I found the answer to my problem. Thanks
Hello @cmotta,
As far as I understand, you want to use native visuals such as table.
If so, please move your topic/question to this Power BI community.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
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 |
---|---|
7 | |
2 | |
1 | |
1 |