The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Power BI Expert, need an advice about DAX.
I am trying to create a new table with one column but with vary row value depends on one condition. Let's say the condition is 15 (or max hours in below case), so I am trying to make a new table with 15 rows contained value of 1-15 for each row.
My problem is, is there any way to create the same table without writing the number one-by-one?
Thank you and really appreciate for the help.
Solved! Go to Solution.
You can use following dax to creat a table
You can use following dax to creat a table
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
7 |