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 13 month consumer wise data in a table along with date column, I hvae calculated the closing balance for each month and it shows in table correctly but now I want to show the same balance as opening balance for next month . can any one help me doing that?
Hi @Aqeelshoukat,
Have you resolved your issue. If you have, please mark corresponding reply as answer, and welcome to share your own solution. So more people will learn new knowledge.
Thanks,
Angelia
Hi @Aqeelshoukat,
You can create a nother calculated column to get next month value.
Next month=LOOKUPVALUE(Table[month],Table[month],Table[month]+1)
Then in table visual, select the 'next month' field as row, the closing balance as value level, you will get expected result. If this is not want you want, please post sample data for further analysis.
Best Regards,
Angelia
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 |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |