Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Find Latest date

Hi All,   The data that I have has all the surverys that were done to all the stores. I want to consider only the latest visit to a store for that month. If the store was not visited on that month...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Bhavya,

     

    Since you have a Date table, it could be a simple measure like below. Please download the demo from the attachment.

    Measure =
CALCULATE (
    MAX ( FACT_DETAILS_KPIS[Visit Date] ),
    FILTER ( ALL ( DIM_DATE ), DIM_DATE[Date] <= MAX ( DIM_DATE[Date] ) )
)

    Find-Latest-date

     

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Bhavya,

 

Since you have a Date table, it could be a simple measure like below. Please download the demo from the attachment.

Measure =
CALCULATE (
    MAX ( FACT_DETAILS_KPIS[Visit Date] ),
    FILTER ( ALL ( DIM_DATE ), DIM_DATE[Date] <= MAX ( DIM_DATE[Date] ) )
)

Find-Latest-date

 

 

Best Regards,
Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Dale,

 

Thank You so much. This is very helpful. 

I also need to apply this in my KPI calculation. I need to find difference between distribution Sku every month vs July. If Distribution sku for a particular month doesn't exist( like Aug in the below example), then we need to consider the last distribution sku(in this case- July) and then find the difference.

 

Any help will be much appreciated.

 

Thank You,

Bhavya

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    It seems the old question. Can you share a dummy sample that is similar to your real data? The main idea is to find the last date and then sum up the sku value where the date equals the last date. 

     

    Best Regards,