Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hi Experts,
for dates there is the dax function called calendar ("Start Date", "End Date") to get a table from startdate to enddate.
Now I am searching for a similar solution/ dax command to get a table easily of a intervall of values with the ability to select the stepsize,
For Example a table from 1 to 5 with a stepsize of 0.1 to get the following one:
| 1.0 |
| 1.1 |
| 1.2 |
| 1.3 |
| ... |
| 4.8 |
| 4.9 |
| 5.0 |
Thank you very much!
Solved! Go to Solution.
Hi @Do5779 You need to create a new parameter with a Decimal range, Or use the "GENERATESERIES" function
I have attached the file for your understanding
@DimaMD Great🤗. Thanks a lot!
I haven't found that dax function. So for all the others : GENERATESERIES-Funktion - DAX | Microsoft Learn
Hi @Do5779 You need to create a new parameter with a Decimal range, Or use the "GENERATESERIES" function
I have attached the file for your understanding
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 3 | |
| 3 | |
| 3 |