Forum Discussion
Create a Calculated Column from Different Tables
Hi, I have data as in the table below: I need period end dates (month end dates from jan to dec 2018). I was able to create a new table with the required dates. However for my further calculatio...
I need to categorise my data in differnt months. I would add a filter for period end date on my dashboard. So if my users want to take a look at the status at the end of october, they would select october and they would have filtered data available just for october.
For example this is what my dashboard looks like when october month is selected:
| New Clients | 30 |
| Lost Clients | 12 |
| Opening balance | 20000 |
| Closing Balance | 65000 |
The data changes to this, when september is selected. An so on.
| New Clients | 10 |
| Lost Clients | 5 |
| Opening balance | 8000 |
| Closing Balance | 45000 |
All fields here are calculated fields. How do i categorise my data in power BI? (Can easily do in excel and Tableau)
Hi Anonymous，
Kindly share your pbix. You can upload the file to dropbox and share the link here.
Regards,
Frank