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.
