Forum Discussion
Beyondforce
9 years agoHelper I
Calculating data from another table - Not Simple!!
Hey There, So here it goes: 1. I have a table called "WeekData" (the first image) 2. The data in the "WeekData" comes from a dump CSV file - So far so good! 3. Check out the first image the da...
Phil_Seamark
9 years agoMicrosoft Employee
Hi Beyondforce
To start with the simple ones, Can we just add the following measures and they will cover your first columns?
Days = DISTINCTCOUNT('Table1'[Day])
Batches per day = COUNT('Table1'[Band based on your sample data, should this be the correct result for these two?
Beyondforce
9 years agoHelper I
Yes, that looks good :)