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
SebSchoon1
Post Patron
Post Patron

Compara Actual data AND historical data, modeling problem

Hello,

 

I would like to verify data Compared in the historice, versus the actual data,

 

i think it is  a modelling problem.

 

here is a picture of my concern

 

SebSchoon1_0-1683199059742.png

i would like to use [Clef unique article]

 

calculate daily on hand stock with this formula 

 

Images de stock = CALCULATE(SUMX('Lignes de mouvement (img stock)','Lignes de mouvement (img stock)'[QUANTITE]),'Calendrier'[Date]<=max('Calendrier'[Date]))
 
But i'd like to have the [Collection] from the "Lignes de mouvement (img Stock) Value calculated.
 
because in the table "Base article" it is the last updated values. Which propagate to my lignes de mouvement (img stock)
 
due to relation.
 
any way to consolitate data?
 
Kind regards!
 

 

 

2 REPLIES 2
VijayP
Super User
Super User

@SebSchoon1 

2 thiings ! 

You are using DateTable in measure to get the cumulative value i guess, which is not really required

2nd thing why date table is used if you want to filter data from other table "Lignes de mouvement (img Stock)

 

Create a simple Table visual in that add base artical and add the value you must get the result  with implied calculation!

If not , please share the sample data to resolve it!




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Hello @VijayP 

 

First of all thank you for the quick reply 🙂

 

I'm using my calendar table because I want to have all values repeated until there's a stock movement.

 

If I do not use the calendar table I only have changes at the time it happens.

So I cannot have the on hand stock daily.

 

My file is 300 mega I don't think I can share it 🙂 but I can for sure provide more details 🤠

 

 

 

 

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.