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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
214 | |
128 | |
117 | |
82 | |
76 |