Forum Discussion

gmasta1129's avatar
gmasta1129
Resolver I
10 months ago
Solved

Help with Power BI Formula to ignore weekend dates

Hello,    I created a measure in Power BI to calculate the difference between sales from one day to the next.  The sales report runs Mon to Fri only. Therefore I need the formula to subtract Monday...
Need Help
  • gmasta1129's avatar
    gmasta1129
    10 months ago

    Hello jgeddes ,

     

    Unfortunately, the below did not work for me. I figured out another formula to use which worked.  

v-venuppu's avatar
v-venuppu
Community Support
10 months ago

Hi gmasta1129 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you jgeddes for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

  • gmasta1129's avatar
    gmasta1129
    Resolver I
    10 months ago

    Hello jgeddes ,

     

    Unfortunately, the below did not work for me. I figured out another formula to use which worked.