The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have the following data which contains the target value for each months' end.
And my requirement is when I select a date, for example, 12/12/2018 I want to get the value of months' end only in 2018 and the current date in last row. If the month in the row column less than month end of the respective monthe the amount should multiply by (working days/total days in a month).
User | Count |
---|---|
15 | |
13 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
12 | |
9 | |
7 |