The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello All.
I have a table Resource Cost, with my resource costs in Septmeber and October, i want to compare the costs between the two month, but i also want to take off what is new (it means resources created in October) to use it for the compare.
I have tried several ways, but none i got what i need.
Could you guys help me?
btw i have a calendar table in my dashboard and there is a relationship with my resources tables
Solved! Go to Solution.
Hi,
Since there is no sample data model, I created it by myself.
I am not sure if it fits your situation.
Check the below picture and the attached pbix file below.
All measures are in the attached pbix file.
Hi,
Has Jihwan_Kim’s reply helped you to find the solution to this problem?
If so, would you like to mark his reply as a solution so that others can learn from it too?
Thanks in advance!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Since there is no sample data model, I created it by myself.
I am not sure if it fits your situation.
Check the below picture and the attached pbix file below.
All measures are in the attached pbix file.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
33 | |
13 | |
12 | |
9 | |
7 |