Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
am facing prob on while use my first row as header,
My first row is date, pls see the attachment snap
2. After use first row as header
i want to know where is my first row date ? where it is gone ?
@ankitpatira @Greg_Deckler @Seth_C_Bauer
Solved! Go to Solution.
This row has gone forever, because PBI doesn't accept date as a column header.
Instead format your columns as text, promote header and then format back to decimals.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Table.PromoteHeaders(#"Previous Step",[PromoteAllScalars=true])
This row has gone forever, because PBI doesn't accept date as a column header.
Instead format your columns as text, promote header and then format back to decimals.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |