Forum Discussion
Snapshot data
Hello Community - Below is a modified sample of data extracted from our ERP system. The accounts (40000, 40010, etc) are general ledger accounts. In order to get a Month to Date value, in this c...
Anonymous
You may apply virtual relationship in DAX measure.
- https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/
- https://community.powerbi.com/t5/Desktop/conditional-join/m-p/340423#M152404
Ashish_Mathur I have this exact setup in my date table already.
I like your approach as it is very simple, but it's not working because I think I need to grab those particular accounts from the Description field. Your approach is causing Jan Feb and March to show gigantic numbers becuase I beleive it is summing all of the "actual value" data. I only need the actual values from those specified general accounts from our accounting system.
Ashish_Mathur
Super User
Super UserHi,
Create a slicer of Account and select the ones youw want.