Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jsevillaiv
Frequent Visitor

Generating new column values from existing table using DAX

Let's say I have a data like this:

jsevillaiv_0-1686827339035.png

A table with "wave" column which has a unique numerical value.

 

Using the table above, the goal is to generate a table like below:

jsevillaiv_1-1686827445720.png

Basically, to generate 4 records consist of decremental values for each "wave" value:
ex.
72 = 69 to 72
73 = 70 to 73
74 = 71 to 74


Is it possible to achieve this using DAX?

Thanks in advance!

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

Create the new table like this:

TableNew = 
    GENERATE (
        TableQ,
       GENERATESERIES(TableQ[Column1] - 3, TableQ[Column1],1) )

View solution in original post

2 REPLIES 2
johnt75
Super User
Super User

You can create a new table like

new table =
SELECTCOLUMNS(
	GENERATE( 'wave', GENERATESERIES( 'wave'[wave] - 3, 'wave'[wave], 1 ) ),
	"wave", 'wave'[wave],
	"wave_coverage", [Value]
)

 

HotChilli
Super User
Super User

Create the new table like this:

TableNew = 
    GENERATE (
        TableQ,
       GENERATESERIES(TableQ[Column1] - 3, TableQ[Column1],1) )

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.