Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am working with leger entries and normally I can user the following to filter out the dates I want.
..02/01/2024
This would show me all records with the end date less than Feb 1 2024
But how I am supposed to relate that into my measures so I can see this value by date?
I have a measure that doesn't factor in the posting date.
I have that table (value entry) linked to my MasterDate table.
When I put the measure and month into a chart i get this
I understand why I get this but I want to know is how do I get all date prior to that date into that measure?
The filters should be
Januaray 2023 = ..01/31/23
Feburary 2023 = ..02/28/23
etc
Solved! Go to Solution.
@bignadad Best not to use the [Date].[Date] notation. Instead:
I tried the calculate type and that worked
That seems like what I need but I'm getting the same value each month now
I tried this code
and the relationship between item ledger entry and value entry
@bignadad Best not to use the [Date].[Date] notation. Instead:
Awesome. Thank you!
@bignadad Not sure I am tracking this. Are you saying you want a running total? If that is the case: Better Running Total - Microsoft Fabric Community
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
85 | |
65 | |
64 |