Forum Discussion
Input Column names gets changed ever month
Input Column names gets changed ever month
Input : Excel
Total input has 30 columns where from column 17 to column 22 there will change ever month so i have tried using the table visual for it
When the data gets refreshed for next month table visual is getting breaked, as column which are changed has been directly added
I have tried this by using unpivot with matrix visual but when ever I tried to export the data from visual getting only 3 column attributes, value, and am not getting total 30 columns.
Needed help in addressing this issue using dax Or M query when ever the data is refreshed visual should not break
3 Replies
Hi R_K_Damera - If you want to keep the table visual dynamic without breaking.
Create a measure that dynamically picks column names
Selected_Month_Column =
VAR CurrentMonth = FORMAT(TODAY(), "MMM-YYYY")
RETURN SELECTEDVALUE('YourTable'[CurrentMonth])Use this measure in a matrix visual to keep your reports flexible.
Ref:
Solved: Datasource column name change - Microsoft Fabric Community
Solved: Datasource column name changed - Microsoft Fabric Community
Hope this helps.
You can try do not change type or use Table.TransformColumnTypes.
It's better to provide some sample data and expected output
Hi R_K_Damera ,
Thanks for the reply from rajendraongole1 / ryan_mayu .
Your needs are vague, so please describe your challenges, desired results, and provide us with sample data in the form of a table or screenshot. This will enable us to diagnose the problem more accurately and make more effective recommendations.
We look forward to hearing from you!
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
