Forum Discussion

Sammy1965's avatar
Sammy1965
New Member
1 year ago

If Query in Dax

I have created a live dashboard where I query the posting date of an order in a field using the Posting Date field. For today   Warenausgänge heute = CALCULATE( COUNT('Archiv_Gebuchte_Warenausgän...
Sammy1965's avatar
Sammy1965
New Member
1 year ago

Hello,

i want the value fron FRiday at monday, because at saturday  and sunday ihave no values.
From Time to time the Storage is working at Saturaday an Sunday.
In this case i need the value from the deay before.....

So I always need the value of the last day in which values are available.
If the weekend was not worked, I need the value from Friday or the last active day before today.
I always need the value of the last active day before today.....


  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Sammy1965 ,

    The formula I provided in my previous post is designed to first identify the maximum date before today where the value is not blank, and then retrieve the value for that date. Could you please let me know if this solution is not working in your fact table? If possible, kindly share some sample data (excluding any sensitive information) along with the expected result based on the provided sample data. It would be helpful to find out the solution. You can refer the following link to share the required info:

    How to provide sample data in the Power BI Forum

    Best Regards