Show values based on the slicers and previous month values also

[NadeemAhamed]

Hello everyone,

Good Day.

I have one table contains the month and A columns and another one for the financial month table for slicers

when user is selecting the months the values should show as on month 

(ex: if user has selected the Aug month then A column value should be shown from Apr-Aug values)

if have relationship TableA and Financial year month then it will show only for the selected month,

TableA

Financial year month'

[BIswajit_Das]

Hello @NadeemAhamed 
You can use a conditional measure and get your required result.

Check out the attached PBI file : https://ufile.io/nbwgo68w

Thanks & Regards...

[Joe_Barry]

Hi @NadeemAhamed 

SQLBI has a great course on this topic https://www.sqlbi.com/p/dax-patterns-custom-time-related-calculations/

This article explains what you need https://blog.enterprisedna.co/learn-how-to-calculate-sales-financial-year-to-date/

Hope this helps

Joe

[NadeemAhamed · Accepted solution]

Thank you all for your reply. 

I have achieved the result. by creating new month table and by creating the measures