Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Total Full Year HELP DAX

Hi,

 

So I am trying to calculate a FULL YEAR for a given month.

 

My data looks something like this (over simplified)

 

Cost Period

2      June 2018

3      July 2019

4      April 2019

1     March 2018

3     Auguat 2018

 

Now, I start by selecting a period, say for example June 2018, I then want to calculate the Full Financial year  on the page as well which would include June 2018 and March 2018 and August 2018

 

How do I build a table to look at the financal months and also to ignore the date filter (as selecting June 2018) should not filter out the data?)

 

Many thanks!

Jese

 

 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors