Forum Discussion
Spread contract value across time
All right, good luck.
You should actually thank Phil_Seamark for that little beauty, until I understood GENERATE (which I came to from reading his book), that problem vexed me from almost the very first day I worked with Power BI!
Community ChampionYou should actually thank Phil_Seamark for that little beauty, until I understood GENERATE (which I came to from reading his book), that problem vexed me from almost the very first day I worked with Power BI!
One thing I don't understand.
In the billing example pbix
There is a Calendar Table with Date column. It was showing me chronological order in the bar graph. When I removed it and put back again to the chronology changed (I think I was playing with my data sample of 5 ).
Is there anything beside Date and Date Hierarchy to play around ?
Like in my ultimate version I got data for 2017,2018,2019,2020 but by choosing Hierarchy I can only see Jan-Dec
Not sure whether it is 2019 which has all the amounts really or all combined by monthly basis.
I would like to see continum of 2017-2020
any idea ?
Thanks