Time inteligence budget in a different granularities.

[Javi77]

HI all.

I have the next issue:

I got a table of sales whith a different granularity and a budget table.

So, i have a dax formula for the (Us Fcst) day and MTD budget and its ok.

The problem here is MTD Us fcst its doesnt work in the matrix but the MTD_Us its worked.

And, i need a QTD and YTD BUDGET for the KPI and the matrix whith no filters of date.

You can get the sample data here

Please someone help me!!!

Sorry by my text...

[Ashish_Mathur]

Hi,

I cannot understand your question.  Show some data and the expected result.

[Anonymous]

I can't say i fully understand what you are trying to do, but from what I can read it seems like you answer will be to use a Date Table.  This would allow you to flag dates with additional groupings such that you could use them in filter or grouping context.

One example is having a Quarter column in the date table, which assigns Q1, Q2, Q3 or Q4 on each date row.  You could next have a column which is QuarterYear which is a concatination of the Quarter value and the Year number.  This would let you uniquely group different quarters from different years.