Forum Discussion
Display records effective on a specific date
I have an interesting conundrum, and I've tried a number of different approaches on the PowerBI forum and none really seem to help me crack this one. I am trying to visualise a table, with a date...
Hi,
The ideal approach would be create one row for every data that lies betweenthe Effective From and Effective To dates. The create a relationship (Many to One and Single) from the newly created date column to the date column of the Calendar Table.