(%) days of the fiscal period and not the month

[Anonymous]

Hi,

I have trouble to create a simple metric that calculates the number of days we are in the fiscal period - because i want an indication on how much (%) of time we have until the end of the period. This is because a fiscal period does not represent a typical calender month - for example, the fiscal period could start in 25th of june and end in 19th of juli. I have a date-table that has actual dates, fiscal year, fiscal period, fiscal year - fiscal period (e.g. 2020-02). However, I dont seem to solve it with a simple DATEDIFF function. Any know how to approach this issue? Many thanks,

Herman

[Anonymous]

Many thanks! This helped a lot!

[amitchandak]

@Anonymous, You need to use Rank as a tool. Rank for Year, Month, Qtr. I have a couple of examples for that

https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123

[Greg_Deckler · Accepted solution]

@Anonymous Time intelligence functions likely won't work for a non-standard calendar. So, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Otherwise, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[aj1973]

Hi @Anonymous 

It sounds like you didn't add a Calendar date to your model, did you? your actual date table doesn't contain the days does it?

DATEDIFF  is a time intelligent function therefore it needs a Calendar table and to get the number of days you also need date in days in your Calendar Table.

A Sample Pibx will help more to solve your issue.

Regards