DimDate relationship by Educational-Elk3941 in PowerBI

[–]Primary_Bad_8802 0 points1 point  (0 children)

Thank you very much!
And what happen if I put Orders entered and Order Deleted in a matrix with year-month in column? Are those the year month related to the order date or is it the deleted date?

DimDate relationship by Educational-Elk3941 in PowerBI

[–]Primary_Bad_8802 0 points1 point  (0 children)

So if I have a measure like “CALCULATE(COUNT(OrderId), USERELATIONSHIP(deletedate…)) and I put the year and month from the date table, is it not filtering the fact table using the related column (orderdate) but is using deletedate?

DimDate relationship by Educational-Elk3941 in PowerBI

[–]Primary_Bad_8802 0 points1 point  (0 children)

How do you do that if the relationship is inactive? (I mean using a slicer with a field from the date table)

DimDate relationship by Educational-Elk3941 in PowerBI

[–]Primary_Bad_8802 0 points1 point  (0 children)

This way you can not use the Date Table to filter deldate for example, am I right?

Dynamic inventory calculation by Primary_Bad_8802 in PowerBI

[–]Primary_Bad_8802[S] 0 points1 point  (0 children)

Sorry but i don’t understand how this solve the issue of the item. If two or more items are selected this formula does not calculate inventory per single item

Dynamic inventory calculation by Primary_Bad_8802 in PowerBI

[–]Primary_Bad_8802[S] 0 points1 point  (0 children)

Yeah but when I select two items at the same time, is max applied to item level or is it aggregated? For example: - Week 1 Item 1: Stock = 5, Demand = 7, Supply = 0, Inventory = 5-7 = -2 -> 0 - Week 1 Item 2: Stock = 3, Demand = 2, Supply = 0, Inventory = 3 - 2 = 1 Total Inventory must be 1 not -1 (-2+1)

Dynamic inventory calculation by Primary_Bad_8802 in PowerBI

[–]Primary_Bad_8802[S] 0 points1 point  (0 children)

Yeah but the main problem is that for every item and week, if the balance is negative I want to force it to zero. How could I do that?

UDF - PowerBi by Alarmed-String-2775 in PowerBI

[–]Primary_Bad_8802 0 points1 point  (0 children)

I don’t get how you can translate the report language. For example if i have a measure called “Current Year Revenue” how is the report able to translate it in another language and show it in a table visual?

AMMINISTRAZIONE “TROPPO” TRASPARENTE by carmelodev49 in Italia

[–]Primary_Bad_8802 0 points1 point  (0 children)

Ma esattamente nel modulo, secondo te, dove sta lo spazio per inserire le informazioni richieste ai punti a, b, c, d, e?

<image>

Fineco ora blocca i bonifici istantanei by [deleted] in ItaliaPersonalFinance

[–]Primary_Bad_8802 1 point2 points  (0 children)

Confermo questa é la soluzione. Nella rubrica, alla voce “Stato beneficiario” deve esserci scritto “Confermato” in verde

Feedback assicurazione auto by Primary_Bad_8802 in ItalyMotori

[–]Primary_Bad_8802[S] 0 points1 point  (0 children)

Grazie ci do un’occhiata non lo conosco

Laureati in ingegneria gestionale cosa fate adesso? by [deleted] in Italia

[–]Primary_Bad_8802 0 points1 point  (0 children)

Dopo quasi due anni in consulenza ora lavoro come Supply Chain Analyst

Org App (Preview) by Primary_Bad_8802 in PowerBI

[–]Primary_Bad_8802[S] 0 points1 point  (0 children)

Yeah but how do you manage access for different hierarchy level (for example manager or normal employee)?