Inverted Triangle Pattern in Power Query using M Functions

Опубликовано: 28 Апрель 2026
на канале: Bhavya Gupta
205
11

This is the Power Query solution to today's ‪@excelbianalytics3781‬ challenge -

If input is 0 or blank, no output.
Similarly, if input is 7, then output would be
* * * * * *
* * * * *
* * * *
* * *
* *
*
*

P.S. - The solution proposed in the video cannot be loaded into Excel if input is blank or 0 but works fine in Query Editor. Just an extra step is required to be able to load it to Excel.
Link of the challenge -   / urn:li:activity:7011903213800964096  . It contains my solution with that tweak as well as brilliant solutions by others also. Do check them out as well!!