This is really cool but the example is too simple to use Power query or power Pivot. Do you have more complex example - multiple entities and reporting periods? My power pivot has a entity ID listed horizontally, plus a reporting period as the pivot drop-down.
I'm a little late to the party, but your video and concepts are incredibly helpful! Thank you.
Very clear introduction to cube function .
Excellent tutorial. Very useful 🙏
This video helped me. Thank you for sharing your knowledge.
Thank you ... I'm glad it helped :)
Nice Sr!
supper excellent
Thank you very much
Hi, could this work with governmental financial statements that have have different gov't funds?
congratulations
Can you do balance sheet and income statement from cash beginning trial balance, disbursement and sales book?
Very nicely done. Could you please share excel files too?
This is really cool but the example is too simple to use Power query or power Pivot. Do you have more complex example - multiple entities and reporting periods? My power pivot has a entity ID listed horizontally, plus a reporting period as the pivot drop-down.
What is the formula for restating a date in a separate cell from mm/dd/yyyy to yyyy-mm?
Hi Jay, For me, I usually use Text.Middle(Text.From(datedata),6,4)&"-"& Text.Middle(Text.From(datedata),3,2). Hop this will help
i still prefer using calculated items
Too bad the download has nothing to do with the Video....
You must have downloaded the wrong file.