sql - Power Bi creating monthly measure from repeated monhts -


i have application database designed following way: (i cannot change it)

 i need able create cash flow can tell me month, property , type amount of month is. figured need in measure in table has months need, not sure how it. 

any appreciated it!

link screenshot, wont let me post directly

even screenshot, not entirely clear me meant repeated month. assuming if repeat_count = 2 , amount = 100 amount_wanted = 200. assuming loaded data power bi. in case need perform following steps:

  1. create calculated column holding month. can using function month(date).

  2. create calculated column amount_wanted = [repeat_count] * [amount]

  3. create new measure: new_measure = sum([amount_wanted])

  4. create matrix visual property , type in rows, month in columns , new_measure in values.


Comments

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

unity3d - Unity SceneManager.LoadScene quits application -

python - Error while using APScheduler: 'NoneType' object has no attribute 'now' -