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
Syndicate_Admin
Administrator
Administrator

time intelligence and groupings

Dear: I need your help with time intelligence and groupings, I explain:

I have a sales data with 5 years of example, I want to compare a period of time of current sale with its similar of a previous year (for the example it is by year), that is to say if I choose the sale 2022, I can compare between the sale 2021 with 2022.

jminanoc_0-1657291394595.png

But it turns out

That the client wants it not to be used for years but for periods of time being the periods of time

Taking as last month June 2022

YTD

January to date (June 2022)

FOOD

Last mobile year (Jul 2021-Jun 2022)

MTH

Last month (Jun 2022)

QTR

Last quarter Q2 (Apr, May, Jun), being Q1 (Jan, Feb, Tue)

QTRM

Last mobile quarter if month is Jun would be May, Apr, Sea

In the example instead of year I must choose period according to the previous table.

Thank you in advance for the help you can give me

Sample File

https://drive.google.com/file/d/1Bk5NH033w-miDjMqNRh5Bki6y_9dQ91N/view?usp=sharing

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

thanks for the answer, but it's not what I need.

Best regards

amitchandak
Super User
Super User

@Syndicate_Admin , Not very clear

 

refer

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

 

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

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.