Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Last period Data based on Date/Quarter/Month/Week Filter selection

Hi,    I am new to Power BI. I got one requirement to show data for last 4 quarters data in a table. So if user selects Date/Quarter/Month/Week, I have to show resepctive data. i.e if user selects ...
Need Help
  • Seward12533's avatar
    Seward12533
    8 years ago

    Its all about filter context, Try creating a lookupdate table with Just YEARMONTHSHORT values

    YEARMONTHS = VALUES(date[YearMonthShort])

    Relate that to your data table and set your slice on that.

     

     

    If doesn't work, you could try NOT using a SLICER to select the month but instead use a disconnected slicer to have user select month, date or whatever and then use that SELECTEDVALUE of what the user selectes as teh desired period in your measures. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Seward12533,

 

Thanks you so much for your reply. I got the logic now. I follow all the steps which you mentioned.

 

1) Created Calendar Table. (Used your Calendar script only)

2) Changed the calculated field as follows: (For testing purpose calculating last 3 days value)

 

OIF_Value_EUR_Calc = VAR LastDt = MAX (V_OPPORTUNITIES[Created_Date]) RETURN
CALCULATE (
SUM ( V_OPPORTUNITIES_OIF[OIF_Value_EUR] ),DateDIM,
FILTER(ALL(DateDIM[Date]) , DateDIM[Date]<=LastDt&&DateDIM[Date]>=LastDt-3))

 

But when I select MonthYear as 'Feb2-2018', The calculated filed not showing me last 3 months value.

'OIF_Value_EUR' and 'OIF_Value_EUR_Calc' showing me same value. Am I missing anything? Could you please help?

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago
How can have PBIX file of this