Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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'
Solved! Go to Solution.
Thank you all for your reply.
I have achieved the result. by creating new month table and by creating the measures
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...
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
Proud to be a Super User! | |
Date tables help! Learn more
Thank you all for your reply.
I have achieved the result. by creating new month table and by creating the measures
User | Count |
---|---|
66 | |
60 | |
47 | |
33 | |
32 |
User | Count |
---|---|
86 | |
75 | |
56 | |
50 | |
45 |