Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |