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, @Anonymous
Could you share your sample pbix or some data sample and expected output for us. Do mask sensitive data before uploading.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Best Regards,
Lin
hi, @Anonymous
Whether data from July File and Aug File will be in the same table?
and what is the logic of "Back Date Entry "?
Best Regards,
Lin
hi, @Anonymous
Is this the case exsit? In Aug File, there are other month data, e.g. AC019 date is 1-Oct-18. If so, what is the date of AC015?
AC015 | 1-Apr-18 | Personal Loan | 20 | Back Date Entry (The amount will be counted in the Aug Volume Report) |
And for your sample data, you could try this way as below:
Step1:
Use LOOKUPVALUE Function to add the the data from Jul table
Jul date = LOOKUPVALUE(Jul[Date],Jul[LAN],Aug[LAN])
Jul Amount = LOOKUPVALUE(Jul[Amount],Jul[LAN],Aug[LAN])
Step2:
Use the logic create new date and Amount column for Aug table like below:
New date = var _a=IF(ISBLANK(Aug[Jul date])&&NOT(Aug[Date]) in VALUES(Aug[Jul date]),Aug[Date],Aug[Jul date]) return IF(ISBLANK(_a),MAX(Aug[Date]),_a)
New amount = var _differece=CALCULATE(SUM(Aug[Amount]),FILTER(Aug,ISBLANK(Aug[Jul date])=FALSE()))-CALCULATE(SUM(Aug[Jul Amount]),FILTER(Aug,ISBLANK(Aug[Jul date])=FALSE())) return var _addrows=CALCULATE(COUNTROWS(Aug),FILTER(Aug,ISBLANK(Aug[Jul date]))) return IF(ISBLANK(Aug[Jul date]),Aug[Amount]+_differece/_addrows,Aug[Jul Amount])
Result:
here is pbix file, please try it.
Best Regards,
Lin
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |