Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Maggie,

 

Thank you for your input, much appreciated.

To clearify a bit:

I have four different spreadsheets and I want to create a flow with columns taken from each spreadsheet.

To make a simple example:

Let's say each spreadsheet has only 3 columns (A, B and C). I want to create a flow which would look like this:

1A-2B-1C-3A-4C-4B-1B-3B....etc

How do I set this up? The data-set reflects the different columns, but the question is how to create the flow here.

 

Best Regards,

Maria