Forum Discussion

FiveAces's avatar
FiveAces
Frequent Visitor
6 years ago
Solved

Calculations with date variables

I'm attempting to build a 12 month visualisation of actual sales based on the financial year and period selected in a slicer. There is a date table (Date) with an active relationship to the fact tab...
Need Help
  • FiveAces's avatar
    FiveAces
    6 years ago

    Hi 

     

    While recreating a sample of this issue I realised that one of the slicers was not filtering the visual which was causing the issue.

     

    I'll try and close/remove this (non) issue.

     

    Thanks for your response.

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi FiveAces 

 

I'm wondering what 's the definition in below formula?Do you refer to the current row? 

VAR selectedYear = SELECTEDVALUE('Date'[FY Year])
VAR selectedPeriod = SELECTEDVALUE('Date'[FY Period])

 And Do you have some sample data or preferably a sample pbix file.

FiveAces's avatar
FiveAces
Frequent Visitor
6 years ago

Hi 

 

While recreating a sample of this issue I realised that one of the slicers was not filtering the visual which was causing the issue.

 

I'll try and close/remove this (non) issue.

 

Thanks for your response.