Forum Discussion
Getting column data from different tables depending on the date
- 1 year ago
Hey Niikk
please check out my solution
DynamicDescription =
VAR TransOldMaxDate = MAX('Transaction_Old'[TransactionDate])
RETURN
IF(
SELECTEDVALUE('DateTable'[Date]) > TransOldMaxDate,
SELECTEDVALUE('Transaction'[Description]),
SELECTEDVALUE('Transaction_Old'[Description])
)
Regards
Govind Sapkade ( Data Analyst , Power BI PL 300 Certified , MS Fabric Enthusiast )
Linkdin : www.linkedin.com/in/govind-sapkade-845104225
Youtube : http://www.youtube.com/@govind_dataanalyst
Hi and thank you for the fast responses! When putting one of these measures at a time in the table it simply loads forever. It's a very big table though. If putting them in Cards and selecting a single row then your solution works govind_021 while the second one turns out blank.
I will probably make two reports and the users has to switch between them when tracking on a transaction row level. Big thnx!!