August 28, 2017 at 5:00 pm
Good day all,
I have the 2 tables, one containing the Fact transaction while other is the date Dimension.
Am able to build the the following DAX columns in the Date Dimension
1. [Day of Month] := DAY('Date'[Date])
2. [NDM] = : DAY(ENDOFMONTH ( 'Date'[Date] ))
And I have the following Measures in fact table
1. [Actual Balance]
2. [Interest]
The two tables is connected with the DateKey from both tables (1:N)
I want to create another measure based on the 2 columns from Date Dimension and the measures from the fact table i.e
[Pool rate] := ([Actual Balance] / [Interest]) * ( [Day of Month] * [NDM]) * 100
Kindly help.
August 30, 2017 at 7:41 pm
Please explain what the measure you're creating is meant to calculate... and how it's meant to work. I think you may have a math error in your formula, but without knowing what it's meant to calculate, I cant tell.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy