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.
Dear All
I have one scenario , table is shown below
In this table I want to calculate the Maximum of bank balance of previos 8 days but when Document type is SI , which will be on documane date 31/12/2022, and bank balance is 2341, i tried this dax formula but its only calculate previous minus 8 days whcih is 6-01-2022, but i need only the previous dates whcih have bank balance. then I want to take amount with SR from previos 8 day add them and subtract them from amount i got form above.
for example = 2341 - (1850+1500) Note == (1850 and 1500 is value with SR whcih is after 31/12/2022)
Solved! Go to Solution.
I fond the solution I just made this Measure take filter
I fond the solution I just made this Measure take filter
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.
Hi thanks for data please find the attach link and for out put check the image.
https://drive.google.com/file/d/1Y0Kf8nX9swUrjcga7dNOG_pCOWuxruQL/view?usp=sharing
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |