Expert Exchange

Hi Vena Community,  I'm Dylan, and I'm looking forward to engaging with you all as a speaker at the upcoming Virtual Banking Event on October 26th as well as this week's #ExpertExchange. In my last ...

Hi Graham that looks great! That's very similar to the solution we came up with as well. In our Foundations report, we declare a variable to represent the fiscal start month (this would be the calendar ...

This intrigued me, as when I started integrating vena with PowerBi, I struggled to get a calendar setup with all the required parameters for a financial year 1 Jul to 30 Jun. I built a power query table ...

It's a really common use case, the way we've accounted for this in the Foundations dashboard is by adjusting the Fiscal Date generated by the CALENDAR() function by the fiscal start month. Let's say your ...

Love this! Thanks @Anton Medvedev What about the fiscal year, any thoughts on how to set up a good date table schema there? I always created multiple columns to realign the dates to a non-calendar year ...

Hi Glen, That's a great question, you always want to make your Power BI schema as flexible as possible, one trick is to use the a combination of MIN(), MAX(), and DATE() something like: CALENDAR( ...

So excited for this series @Anton Medvedev! Personally, I love the having dynamic end dates for the Calendar function! VAR CurrentYear = YEAR(TODAY()) // Identify current year VAR EndYear = CurrentYear ...