Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date Filter in measure

Hey Power BI Community! I need in a measure a date filter like Date is after 01.10.2020 for calculation. How can I achieve this? Here is my measure:  DOA rate (monthly) =(DIVIDE('Parts pe...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Anonymous ,

     

    Be aware that DAX measure are based on row context so any given value from slicers, filters, interactions with other visualizations, variables, relationships and so on can influence your result.

    It is very difficult to analyze without looking at the data and just by imagining

    Any chance you can share a PBIX file with dummy data or share sample data and the formula of [Count of Parts]?

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

var result =(DIVIDE('Parts per Month'[DoAs], [Count of Parts]))+0
return if(result, result, IF(MAX(Dates[Date2])>DATE(2019,9,30),0, BLANK())) 
 
The Bold part not clear to me. is there any sample data to answer this question ! Share your Kudoes
Anonymous's avatar
Anonymous
Not applicable
6 years ago

VijayP  Thank you for your respond.

I am sorry for the confusion. 

 

Lets take this measure= ((DIVIDE('Parts per Month'[DoAs], [Count of Parts]))

I want to calculate the value of the last Financial year (09.09.2019-30.09.2020) - the value of the new financial year (01.10.2020 - )

So I think I need to make two measures with different date filter. How can I calculated that.

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Be aware that DAX measure are based on row context so any given value from slicers, filters, interactions with other visualizations, variables, relationships and so on can influence your result.

    It is very difficult to analyze without looking at the data and just by imagining

    Any chance you can share a PBIX file with dummy data or share sample data and the formula of [Count of Parts]?

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.