Hi, I would check out SQLBI's DAX calendar, in there they calculate the last date of the fiscal year. This is all documented for you and available to download, i'm sure you'll be able to work out how they do it. Fiscal EndOfYear : 8/31/2018 (Date) ...
Hi, you can use drill through to drill into the data. ------------------------------ Ben Howard, UK. Please mark any answer as recommended if it helps you. ------------------------------
Hi, Sam is right that if you want to keep your data on your local machine then you'll need to install a Gateway and set it up, and of course keep your PC on during any/all refresh processes. A better solution is to store the base data in teams/sharepoint ...
Hi I have fiscal year & date in my calendar table and I wanted a create a new coloum in my calendar table and stamp every fiscal yearend date as 31/3/2011, 31/3/2012 etc Col FY Requirement (End date of the fiscal year) 15-16 31/3/16 16-17 ...
Hi all, I have total sales data of a retailer and sales data of some of his channels. I'd need a solution to show "the rest" of his sales in a column for each product. I got his customer data table shown below. The table shows the total sales per ...
¿Les ha pasado que dentro de una misma sección en un cuadro de mando de Power BI, algunos usuarios prefieren gráficas de barras y otros prefieren una tabla sencilla y y quedamos analizando como cubrir esa solicitud? ¿O que algunos usuarios solicitan ver ...