Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |