Forum Discussion
Group installments by date
Hi, Anonymous
Thank you for your feedback.
Q1. There is no difference. I created the year column in Power Query Editor, and yours is created by Calculated Column, so that is why the symbol looks different.
Q2. In a general situation, I prefer to have a thin-fact-table. The first question's table was not that wide so I created a measure without connecting the tables. However, the second question's table was wider than the first one, so I wanted to transform it into a different structure to have a thin table. In this case, I could connect to the calendar table, and the measure is so simple to write.
Please check the link down below.
The result is the same as the first one, but the measure is so simple, if you transform the table structure. Transforming the table structure is easily done in Power Query Editor.
Payment Total V2 =SUM(DataV2[payment])Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Hi, Anonymous
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
The measure is in the sample pbix file.
Payment Total =
CALCULATE (
SUM ( Data[payment1] ),
FILTER (
Data,
Data[paydate1] >= MIN ( 'Calendar'[Date] )
&& Data[paydate1] <= MAX ( 'Calendar'[Date] )
)
)
+ CALCULATE (
SUM ( Data[payment2] ),
FILTER (
Data,
Data[paydate2] >= MIN ( 'Calendar'[Date] )
&& Data[paydate2] <= MAX ( 'Calendar'[Date] )
)
)
+ CALCULATE (
SUM ( Data[payment3] ),
FILTER (
Data,
Data[paydate3] >= MIN ( 'Calendar'[Date] )
&& Data[paydate3] <= MAX ( 'Calendar'[Date] )
)
)
https://www.dropbox.com/s/b3yi7ct34iqoqww/justchill.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/