Forum Discussion
Show records as at a certain date
Hi all, I have a conundrum. The conundrum being multiple tables connected via PID (primary identifier). All tables have a record start date and a record end date (end date is blank if it's a curr...
Thanks ManuelBolz and dufoq3 .
I agree that exploding the dates would not be a viable option, i'm already sitting at a 9.6Gb PBix file... it would die.
I did decide to go somewhat via the custom function way, but instead coding it in Synapse Studio. I have a main table that has the PID & Date combination (union of all tables to get all values), then in that same table i have listed for each PID/date combination, which date field should be used in each of the tables.
I hope doing this server side in Synapse means the powerBI won't be too slow.