Forum Discussion
peterg0417
Helper III
3 years agoDon't Load Data Until All 3 Sources Are Ready
Hey all, I'm wonering whether this is possible (preferrably in DataFlows, but whatever is the easiest method will do). I'm currently extracting data from 3 different sources (or Lines of Busi...
- 3 years ago
Hi peterg0417 ,
Please write the calculated column like Dist_count_LOB = CALCULATE(DISTINCTCOUNT('GPM Data'[LOB]))
peterg0417
Helper III
3 years agoDo you mean which LOB is the first to have the data? No. It varies.
I'm wondering if grouping by DateKey (eg. 2022-09-30) and then distinct count LOB would work, but I can't figure the logic out. I tried creating a Calculated table in Desktop with JUST the Date key from my data table, like so:
But it's not working.
This is the result I was expecting to get:
My thought process is that I can use the "Count of LOB" column as a filter for the entire report, to only show data when it equals 3.
Aburar_123
Solution Supplier
3 years agoHi peterg0417 ,
Please write the calculated column like Dist_count_LOB = CALCULATE(DISTINCTCOUNT('GPM Data'[LOB]))