Forum Discussion
Solved
How to align multiple tables and create dynamic last 3 months columns when migrating from Tableau
I am trying to migrate a Tableau dashboard to Power BI, and I’m having difficulty building the tables in the desired format. I currently have 3 separate tables: Matrix table – showing Classroom, S...
Hi,
This is a start
Hi,
Click on the hierarch symbol.
Sample data is in the format
| YRMNTH | spec | numer | deno |
| 202402 | IT | 2 | 10 |
| 202506 | FP | 3 | 24 |
| 202506 | FP | 4 | 32 |
| 202402 | IT | 2 | 12 |
| 202507 | FP | 1 | 45 |
| 202506 | IT | 2 | 12 |
| 202508 | FP | 3 | 23 |
Result Expected where jun-2025, jul-2025,aug-2025 is dynamic column header showing last 3 months from current date. Basic calculation is numer/deno for each spec
| spec | PreviousYear | Jun-2025 | Jul-2025 | Aug-2025 | YTD |
| FP | 0 | 0.125 | 0.0222 | 0.13 | 0.088 |
| IT | 0.18 | 0.16 | 0 | 0 | 0.16 |
Ashish_Mathur
Super User
Super UserHi,
This is a start
Hi Ashish_Mathur, thanks for sharing the pbix file, i am able to replicate the calculations but while displaying i am getting column as spec, ratio PY, Ratio, Ratio YTD in your pbix file as well.. can you tell how did you create the matrix table, it might be i missed something. see the screenshot attached.
- Ashish_Mathur
Hi,
Click on the hierarch symbol.