Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Day!
I have a sample problem here, I want to get the total counts/number of data in a specific month , but the data (Production/claims) has 2 different date columns like the ff:
any ideas and advice for this problem?
Thanks in advance.
-Ran
Solved! Go to Solution.
Hello @RanHo ,
You create a dim date table between these two tables that you link both tables to and filter through it.
check this out https://youtu.be/2f7dYB1l84g
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hello @RanHo ,
You create a dim date table between these two tables that you link both tables to and filter through it.
check this out https://youtu.be/2f7dYB1l84g
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
@Idrissshatila Thanks for the answer, I'll take it as an answer/solution.
As for anyone having problem like this , check out this link too: https://www.youtube.com/watch?v=TnyRsO4NJPc
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |