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.
Jihwan, you absolutely rock!!
It was exactly what I was looking for!
I just have two more questions...
The first one is concerning the calendar you prepared in order to make it work:
So, I am used to create the date columns that I need, and the "year" one is always of good use, sure!
But, I've noticed that on your pbix file, the year in your calendar table appear as:
with the ∑ symbol... Mine doesn't appear like that.
It shows like this (please note that I'm using "year" in pt here):
but once I've added the dax function you recommended, it works as well.
I am wondering if the outcome gets affected somehow...
And the second one...
What would be the best way to add one more filter to classify these payments...
Using the same example table I've provided you with, the status columns to classify the payments can appear as:
I've uploaded the example table to dropbox like you did, I hope it helps:
https://www.dropbox.com/s/t5o7c859qi9xjfi/justchill.xlsx?dl=0
Thanks again!
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, Jihwan, sorry I couldn't come back to it sooner!
It took me a while to get the modifications you have done with the tables into the power query editor.
In a way it really worked, but I was hoping you could help me modifying it to an easily updatable way...
Once I add another line to it, for example, with the "a" category, I get the 0x80040E4E error and another one saying I can't have duplicate value.
Would the dax solution be an option for this updatable report?
Also, would you happen to know if including a "source column", for example containing "internal", "external" and "pending" filterable text values to the dax formula would make it too complicated?
Thank you so much so far 😄
Hi, Anonymous
Sorry that it is quite difficult for me to understand your question.
If it is OK with you, could you please share your sample pbix file's link?
After I transform the fact table, there is only one simple measure applied which is below.
Payment Total V2 =SUM(DataV2[payment])I might miss something important concept in your case.