Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |