Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Here is my predicament:
I have multiple sources that fresh on a monthly basis (bring in data and associated year-month dating).
However, some sources are only updated on the "rare occasion" (say quarterly on average).
SO, when I go to combine the sources, it looks like the data from the "rare ocassion" table is missing for months it wasn't refreshed in.
See below table for example:
Now, if I have a date slicer from my calendar table, select feb-23, agent will appear blank.
I don't want it to be blank, but rather, I want the most recent agent date applied backwards until a "new agent" is later updated.
Does this make sense?
Solved! Go to Solution.
Read about "Fill Down/Up" in Power Query. Or use measures that handle the required logic.
Read about "Fill Down/Up" in Power Query. Or use measures that handle the required logic.
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |