Earn 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