Forum Discussion
Relational tables
Dashboard below is drawing from sources from DM faddere 2018 hentet fra fadderskap, DM faddere 2018 hentet fra kontakt and DM Vervegiro reports. I need to include payment from the table below (DM fad...
Hi Anonymous
Thank you for sharing so many details.
For your requirement, i'm not very clear.
Also, it is complex of your data.
I'm stuck on making a test by these.
Based on my knowledge, to "include payment from the 8th of January 2018 to the 20th of Feb 2018",
you could create a measure like
Measure=calculate(sum('table name'[payment]),filter(all('table name'),[date]<=date(2018,2,20)&&[date]>=date(2018,1,8)))
Best Regards
Maggie
Hi,
Also the time lapse isn't so relevant here in this first instance.
Thank you,
Maria