Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Sorry if this has been answered thousands of times earlier.
From a server I have data of subscriptions extracted to power BI. I have problems dealing with values between two dates (I.e. Start, End dates)
E.g.
Start: 15.01.21
End: 14.03.21
List Rate: 10
Qty: 10
MRR: 100
For each reporting month I want to show this contract's value. Desired output result in something like this
January: MRR*(31-15)/31 = 51,612
February: = 100
March = (14/31)*100 = 45,16
Now optimally the sum of January and March value should be 100, but the duration of the contract could be a floating point number as well (Start 17.01.21 , End: 03.09.21 for example.
Solved! Go to Solution.
Hi, @Anonymous
Please check the below picture and the sample pbix file's link down below.
I tried to create a sample pbix file based on your exlanation.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
Please check the below picture and the sample pbix file's link down below.
I tried to create a sample pbix file based on your exlanation.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Anonymous , Refer to the file attached, see if that can help
or this blog
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |