Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello. I have two measures: one measure returns the RecordPeriod (RecPD) from a slicer (only one period can be chosen). The other measure extracts the year from that slicer value. For example, say the user selects "202402" as the RecPd. The Year Extract measure would return "2024".
How can I sum up a "Net" column of values depending on what the user chooses for the RecPD? This is for a balance sheet and needs to be cumulative. For example, using the above sample of 202402, the "Net" total would include "Net" values from 202400, 202401 and 202402. Here is what I tried, but it did not work:
Solved! Go to Solution.
@rmcgrath , Seem like [RecPd Selection] is measure. Use filter function
calculate(Sum(RawGLData[Net]), filter(dimDate, dimDate[Period] >= ([Year Extract] & 00) && dimDate[Period] <= [RecPd Selection] ))
@rmcgrath , Seem like [RecPd Selection] is measure. Use filter function
calculate(Sum(RawGLData[Net]), filter(dimDate, dimDate[Period] >= ([Year Extract] & 00) && dimDate[Period] <= [RecPd Selection] ))
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |