Forum Discussion
How to align multiple tables and create dynamic last 3 months columns when migrating from Tableau
Hi,
This is a start
Hi,
Click on the hierarch symbol.
Community Championleodec11 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
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
Hi,
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.