Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Let's say I have a data like this:
A table with "wave" column which has a unique numerical value.
Using the table above, the goal is to generate a table like below:
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!
Solved! Go to Solution.
Create the new table like this:
TableNew =
GENERATE (
TableQ,
GENERATESERIES(TableQ[Column1] - 3, TableQ[Column1],1) )
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]
)
Create the new table like this:
TableNew =
GENERATE (
TableQ,
GENERATESERIES(TableQ[Column1] - 3, TableQ[Column1],1) )
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |