Forum Discussion
Need help - Fill dates columns with values - DAX
[m1] this is a measure you need to create it
and you need to create a date table and disable hierarchy
look carefully at the model and how I created the relationship between the tables
pls try this
Thank you for you kind support, Ahmedx, but I still couldn't make it work. The resolution you showed is what I'm looking for, but I got some errors. The first one, and I think I solved myself, in the line 4 of the DAX you created, i changed the "date[maturity date]" for 'Table'[maturity date], because I don't have a "date" table. The other error is on that "[m1]", power bi gave the error (I translated to english because I'm using the Brazilian power bi): "Unable to locate column 'm1' or it is not allowed to use it in this expression."
Do you have some ideia on how to solve this? anyway, thank you for the last answer
[m1] this is a measure you need to create it
and you need to create a date table and disable hierarchy
look carefully at the model and how I created the relationship between the tables
