Forum Discussion
Generate new rows based on previous data
Hi, I have two tables, one with accounting and one with forcasts. I need to use both in order to create a view with some information I need for my accounting. The problem is mainly with the foreca...
So, in general, when you are trying to invent rows in DAX, you use GENERATE or GENERATESERIES
Hi,
I tried the generate series as you mentioned a while back but got stuck as I need to loop though 2 dimensions, date and project. This would be fine if there was a loop in Dax but I searched for it and couldn’t find any except using a second table.
I tried the generate series as you mentioned a while back but got stuck as I need to loop though 2 dimensions, date and project. This would be fine if there was a loop in Dax but I searched for it and couldn’t find any except using a second table.